我们可以在sqlserver中获取现有表的create语句吗 [英] Can we get the create statement of an existing table in sqlserver

问题描述

大家好，

我在sqlserver数据库中有一个名为tblExample的表.有什么方法可以获取我创建的特定表的create语句?如果有的话请告诉我.

Hi all,

Iam having a table named as tblExample in my sqlserver database. Is there any method for getting the create statement of that particular table what I created...? If there means please tell me.

Thanks in advance.

推荐答案

右键单击表名->.脚本表为->创建TO

right click on table name -> script table as -> Create TO

sp_help [table name]应该可以.

sp_help [

sp_help [table name] should do it.

sp_help[^]

regards
Michel

这篇关于我们可以在sqlserver中获取现有表的create语句吗的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！