SQL语句查询某表的所有字段及数据类型
SELECT name AS column_name , TYPE_NAME(system_type_id) AS column_type , max_length , is_nullable FROM sys.columns WHERE object_id = OBJECT_ID(N'customerbase') --customerbase 为表名
SQL语句查询某表的所有字段及数据类型
SELECT name AS column_name , TYPE_NAME(system_type_id) AS column_type , max_length , is_nullable FROM sys.columns WHERE object_id = OBJECT_ID(N'customerbase') --customerbase 为表名
转载于:https://www.cnblogs.com/feng-yuan/p/6117385.html