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'表名')
转载于:https://www.cnblogs.com/wuyifu/archive/2012/11/28/2793461.html
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'表名')
转载于:https://www.cnblogs.com/wuyifu/archive/2012/11/28/2793461.html