sql server中查找特定类别的列的写法

(编辑：jimmy 日期: 2024/11/10 浏览：2)

复制代码代码如下:
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)

上一篇：自动清理 MSSQL Server Table Collation问题的解决方法

下一篇：N字符在Sql Server字段类型中的重要性概述