select owner as database_name,
owner as table_schema,
tabname as table_name,
tabtype as table_type
from systables where tabname =
SELECT p1.colname,
p2.colname,
p3.colname,
p4.colname,
p5.colname,
p6.colname,
p7.colname,
p8.colname,
p9.colname,
p10.colname,
p11.colname,
p12.colname,
p13.colname,
p14.colname,
p15.colname
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';
}