Select Table Cloumns type size etc.

在SQL Server中 用 SQL 语句获得表结构,

 

查询系统表INFORMATION_SCHEMA.TABLES得到所有用户表结构：(所有者,表名,列名,类型,大小,默认值等等)

SELECT T.TABLE_SCHEMA as [TableOwner],T.TABLE_NAME as [TableName],C.COLUMN_NAME as [ColumnName],C.DATA_TYPE as [DataType],C.CHARACTER_MAXIMUM_LENGTH as [Size],C.NUMERIC_PRECISION as [Precision],C.COLUMN_DEFAULT as [DefaultValue],C.IS_NULLABLE as [AllowNull] , COLUMNPROPERTY( OBJECT_ID(T.TABLE_NAME),C.COLUMN_NAME,'IsComputed') as IsComputed FROM INFORMATION_SCHEMA.TABLES T JOIN INFORMATION_SCHEMA.COLUMNS C on T.TABLE_NAME = C.TABLE_NAME WHERE T.TABLE_NAME NOT LIKE 'sys%'AND T.TABLE_TYPE = 'BASE TABLE' AND T.TABLE_NAME <> 'dtproperties' AND T.TABLE_SCHEMA <> 'INFORMATION_SCHEMA' ORDER BY T.TABLE_NAME, C.ORDINAL_POSITION