SELECT a.name AS 表名, b.name AS 字段名, c.name
AS 字段类型,b.length
FROM sysobjects a, syscolumns b, systypes c
WHERE a.id = b.id
AND a.xtype = 'U'
AND b.xtype = c.xtype
and c.name='varchar'`
查询数据库里所有的varchar类型的字符串
最新推荐文章于 2023-07-09 13:05:42 发布