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

【文件属性】：

文件名称：sql server中查找特定类别的列的写法

文件大小：15KB

文件格式：PDF

更新时间：2024-01-05 03:25:26

SQL 类别

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