select owner as database_name,
owner as table_schema,
tabname as table_name,
tabtype as table_type
from systables where tabname =
SELECT p1.colname as col1,
p2.colname as col2,
p3.colname as col3,
p4.colname as col4,
p5.colname as col5,
p6.colname as col6,
p7.colname as col7,
p8.colname as col8,
p9.colname as col9,
p10.colname as col10,
p11.colname as col11,
p12.colname as col12,
p13.colname as col13,
p14.colname as col14,
p15.colname as col15
from sysconstraints
join systables
on sysconstraints.tabid = systables.tabid
join sysindexes on sysconstraints.idxname = sysindexes.idxname
left outer join syscolumns as p1 on p1.colno = sysindexes.part1 and p1.tabid = systables.tabid
left outer join syscolumns as p2 on p2.colno = sysindexes.part2 and p2.tabid = systables.tabid
left outer join syscolumns as p3 on p3.colno = sysindexes.part3 and p3.tabid = systables.tabid
left outer join syscolumns as p4 on p4.colno = sysindexes.part4 and p4.tabid = systables.tabid
left outer join syscolumns as p5 on p5.colno = sysindexes.part5 and p5.tabid = systables.tabid
left outer join syscolumns as p6 on p6.colno = sysindexes.part6 and p6.tabid = systables.tabid
left outer join syscolumns as p7 on p7.colno = sysindexes.part7 and p7.tabid = systables.tabid
left outer join syscolumns as p8 on p8.colno = sysindexes.part8 and p8.tabid = systables.tabid
left outer join syscolumns as p9 on p9.colno = sysindexes.part9 and p9.tabid = systables.tabid
left outer join syscolumns as p10 on p10.colno = sysindexes.part10 and p10.tabid = systables.tabid
left outer join syscolumns as p11 on p11.colno = sysindexes.part11 and p11.tabid = systables.tabid
left outer join syscolumns as p12 on p12.colno = sysindexes.part12 and p12.tabid = systables.tabid
left outer join syscolumns as p13 on p13.colno = sysindexes.part13 and p13.tabid = systables.tabid
left outer join syscolumns as p14 on p14.colno = sysindexes.part14 and p14.tabid = systables.tabid
left outer join syscolumns as p15 on p15.colno = sysindexes.part15 and p15.tabid = systables.tabid
where systables.tabname =
and constrtype = 'P'
select colname as name,
coltype as primaryKey,
coltype as identity,
coltype as nullable,
coltype as dbDataType,
collength as length,
'' as default
from syscolumns where tabid= (select tabid from systables where tabname =)
var asHex=0;
var lowTwo='';
if (arguments.num lt 256){
return arguments.num;
}
asHex=FormatBaseN(arguments.num,16);
lowTwo=mid(asHex,len(num)-1,2);
lowTwo=inputBaseN(lowTwo,16);
var asHex=0;
var third=0;
if (arguments.num lt 256){
return 'true';
}
asHex=FormatBaseN(arguments.num,16);
third=mid(asHex,len(arguments.num)-2,1);
if (third eq '1'){
return 'false';
}