sql server使用sql查询表的字段类型，长度，精度，是否为空等

sql server使用sql查询表的字段类型，长度，精度，是否为空等

SELECT o.name as tab_name,c.name as col_name,t.name as col_type,c.prec length,isnullable,c.scale
FROM sysobjects o
JOIN syscolumns c on o.id=c.id
JOIN systypes t on c.xusertype=t.xusertype where o.name='Base_Customer'
and o.type ='u'

sysobject系统表属性如下,转自
https://blog.csdn.net/lanxingbudui/article/details/88060657

syscolumn属性如下
转自https://blog.csdn.net/duan13431255543/article/details/87913981