sqlserver中查询表字段的sql语句
时间：2021-07-01 10:21:17
帮助过：92人阅读
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
finished
sqlserver中查询表字段的sql语句
标签：isnull font name rom null arch weight 2.x arc
