摘要：
1、简易法：使用以下SQL语句：SELECT COLUMN_NAME, DATA_TYPE, CHARACTER_MAXIMUM_LENGTH, NUMERIC_PRECISION, NUMERIC_SCALE,IS_NULLABLE, COLUMNPROPERTY(OBJECT_ID(TABLE_NAME), COLUMN_NAME, 'IsIdentity') AS IS_AUTOINCREMENT,COLUMN_DEFAULTFROM INFORMATION_SCHEMA.COLUMNSWHERE TABLE_NAME = 'yourTableName'O 阅读全文
