SELECT table_name AS 数据表名, column_name AS 字段名, ISNULL(column_default,'') AS 默认值, is_nullable AS 是否允许为NULL, data_type AS 数据类型, ISNULL(ISNULL(ISNULL(character_maximum_length,numeric_precision),datetime_precision),1) AS 类型长度 FROM information_schema.columns --where table_name ='T_TicketType' WHERE NOT table_name IN('sysdiagrams','dtproperties')