SQL Server相关系统信息

1。得到数据库用户自定义表所有字段类型

SELECT A.*, T.name
FROM
(
 SELECT user_type_id FROM sys.columns
 WHERE object_id IN (SELECT object_id FROM SYs.objects WHERE type = 'U')
 GROUP BY user_type_id
) A
LEFT OUTER JOIN sys.types t
ON A.user_type_id = t.user_type_id

2。得到指定字段类型的表名，字段名及字段类型

SELECT C.Name AS FieldName, O.object_id, O.name AS ObjName, T.name AS FieldType
FROM sys.columns C
LEFT OUTER JOIN sys.objects O
ON C.object_id = O.object_id
LEFT OUTER JOIN sys.types t
ON C.user_type_id = t.user_type_id
WHERE O.TYpe = 'U'
AND T.name IN ('numeric')