1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25
| SELECT DISTINCT
Column_name = c.name,
Type = t.name,
Length = c.length,
Prec = c.prec,
Scale = c.scale,
Nulls = convert(bit, (c.status & 8)),
Default_name = object_name(c.cdefault),
Rule_name = object_name(c.domain),
Ident = convert(bit, (c.status & 0x80)),
Default_Ddl = isnull (d.status & 4096, 0),
Rule_Ddl = isnull (r.status & 4096, 0),
DefaultId = c.cdefault,
RuleId = c.domain,
Column_len = char_length(c.name),
Type_len = char_length(t.name)
FROM dbo.syscolumns c
,dbo.systypes t
,dbo.sysprocedures d
,dbo.sysprocedures r
WHERE c.id = object_id('sysobjects')
AND c.usertype *= t.usertype
AND c.cdefault *= d.id
AND c.domain *= r.id
ORDER BY c.colid |
Partager