SELECT
LOWER (SO.name) tableName,
LOWER (SC.name) colName,
LOWER (ST.name) typeName,
SC.colid colId,
SC.isnullable nullable
FROM
sysobjects SO,
syscolumns SC,
systypes ST
WHERE
SO.id = SC.id
AND SO.xtype = 'U'
AND SO.status >= 0
AND SC.xtype = ST.xusertype
AND so.name = 'sys_position_dept'
ORDER BY
SO.name,
SC.colid
sqlserver 查看表名字段名,字段类型
最新推荐文章于 2024-06-19 16:02:33 发布