finished
sqlserver中查询表字段的sql语句
标签：isnull font name rom null arch weight 2.x arc
sqlserver中查询表字段的sql语句
t1.name table_name,t2.name col_name,t3.name+‘(‘+convert(varchar(200),t2.length)+‘)‘ datatype,t2.isnullable from
sysobjects t1
join syscolumns t2 on t2.id=t1.id
join systypes t3 on t3.xtype=t2.xtype
where t1.name=‘table_name‘ order by t2.colorder