在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