sql server中查找特定类别的列的写法
时间：2021-01-26 15:24:07|栏目：MsSql|点击： 次
复制代码 代码如下:
select a.name, o.name AS TableName, o.type, a.id, o.object_id, o.schema_id
FROM sys.syscolumns AS a INNER JOIN sys.systypes AS b ON a.xtype = b.xtype
AND b.name = 'nvarchar'
INNER JOIN
sys.objects AS o ON a.id = o.object_id
WHERE (o.type = 'u')
AND (o.schema_id = 1)
上一篇：Sql server中内部函数fn_PhysLocFormatter存在解析错误详解
栏 目：MsSql
下一篇：sql中 order by 和 group by的区别
本文地址：http://www.codeinn.net/misctech/51553.html
