<pre id=\"best-answer-content\" class=\"reply-text mb10\">通过下面的sql可以得到:
SELECT
TABLE_CATALOG AS [Database], TABLE_SCHEMA AS Owner, TABLE_NAME AS TableName, COLUMN_NAME AS ColumnName,ORDINAL_POSITION AS OrdinalPosition, COLUMN_DEFAULT AS DefaultSetting, IS_NULLABLE AS IsNullable, DATA_TYPE AS DataType,CHARACTER_MAXIMUM_LENGTH AS MaxLength, DATETIME_PRECISION AS DatePrecision,COLUMNPROPERTY(object_id(TABLE_NAME), COLUMN_NAME, \'IsIdentity\') as IsIdentity
FROM
INFORMATION_SCHEMA.COLUMNS WHERE
(TABLE_NAME = \'Hello\') |