CREATE TABLE master.sys.syscolpars (
id int NULL,

number smallint NULL,

colid int NULL,

name sysname NULL,

xtype tinyint NULL,

utype int NULL,

length smallint NULL,

prec tinyint NULL,

scale tinyint NULL,

collationid int NULL,

status int NULL,

maxinrow smallint NULL,

xmlns int NULL,

dflt int NULL,

chk int NULL,

idtval varbinary NULL)

GO