摘要:
select TableName = O.name,
OWNER = USER_NAME(O.uid),
FieldId = C.colid,
FieldName = C.name,
FieldType = T.name
+ CASE
WHEN T.name IN (N'decimal',N'numeric')
THEN N'(' + CAST(C.prec as varchar) + N',' + CAST(C.scale as varchar) + N')'
WHEN T.name = N'float' OR T.name like N'%char'
OR T.name like N'%binary'
THEN N'(' + CAST(C.prec as varchar) + N')'
ELSE N''
END, 阅读全文