SQLSEVER 查询字段名,字段类型,长度
SELECT syscolumns.name AS 字段名,systypes.name AS 数据类型,syscolumns.length AS 长度
FROM syscolumns INNER JOIN systypes ON systypes.xtype=syscolumns.xtype
WHERE id=(SELECT id FROM sysobjects WHERE name='表名')
原创
2021-03-11 10:32:21 ·
969 阅读 ·
0 评论