如何在sqlserver TSQL中获取table_definition [英] how to get table_definition in sqlserver TSQL

问题描述

大家好，

我在sqlserver中执行此查询

Hi all,

I execute this query in sqlserver

SELECT * FROM INFORMATION_SCHEMA.views

回到我

which returns me

view_definition
"CREATE view v1  as  (select TABLE_name, COLUMN_NAME from INFORMATION_SCHEMA.COLUMNS)"

是否有这样的查询返回Table_definition

is there any query like this which returns me Table_definition

create table tablename
(
id numeric,
fname nvarchar(50)
 
)

推荐答案

http: //www.sqlteam.com/forums/topic.asp?TOPIC_ID=53007 [

这篇关于如何在sqlserver TSQL中获取table_definition的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！