systables:描述数据库中的很张表;
syscolumns :描述数据库中表的列;
sysindexes :描述数据库中列的索引;
sysfragments:存储了分段索引的片段信息;
sysfragauth:表识别列级权限;
sysviews:描述了数据库中定义的每个视图;
sysdpend:描述了视图是如何依赖其他视图和表的;
syssyntable:定义每一个同义词及其所代表的对象;
sysconstraints :记录了加载在数据库表列上的约束;
sysreferences:列出了放置在数据库上的参照约束,它为数据库的每个参照约束建立一行
syscoldepend:记录了涉及检查约束的所有列,包括在约束中每列都会在syscoldepend表中创建一行;
sysprocedures:存放数据库中每个过程的特征;
sysprocplan:装载了过程执行所需的两项内容(执行计划或查询计划、附属列表);
sysprocauth:描述授予存储过程的权限;
systriggers:装载了关于触发器的信息;
sysblobs:确定BLOB列的存储位置;
sysroleauth:描述授予用户的角色;
sysobjstate :存储了关于数据库对象的状态信息;
sysvlolations:违例或诊断表;
sysdefaults:描述数据库中表的列的默认值;
-- 查询库下所有字段的主键信息 不包括 系统表和视图
select unique
t.tabname
, (select c.colname from syscolumns c where c.tabid = i.tabid and c.colno = i.part1 ) as pk_1
, (select c.colname from syscolumns c where c.tabid = i.tabid and c.colno = i.part2 ) as pk_2
, (select c.colname from syscolumns c where c.tabid = i.tabid and c.colno = i.part3 ) as pk_3
, (select c.colname from syscolumns c where c.tabid = i.tabid and c.colno = i.part4 ) as pk_4
, (select c.colname from syscolumns c where c.tabid = i.tabid and c.colno = i.part5 ) as pk_5
, (select c.colname from syscolumns c where c.tabid = i.tabid and c.colno = i.part6 ) as pk_6
from sysindexes i , systables t
where i.tabid = t.tabid and i.idxtype = "U" and i.idxname in ( select c.idxname
from sysconstraints c, systables t, outer (sysreferences r, systables t2, sysconstraints c2)
where
t.tabid = c.tabid
and r.constrid = c.constrid
and t2.tabid = r.ptabid
and c2.constrid = r.constrid
and c.constrtype = "P" )