gdjlc

摘要： 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, 阅读全文