Firebird常用系统表Sql语句

--得到数据库的所有者名称
SELECT distinct RDB$OWNER_NAME AS DATABASE_OWNER
from RDB$RELATIONS
WHERE (RDB$SYSTEM_FLAG = 1);
--根据表名得到表的主键
SELECT RC.RDB$CONSTRAINT_NAME AS CONSTRAINT_NAME,
I.RDB$RELATION_NAME AS TABLE_NAME,
S.RDB$FIELD_NAME AS COLUMN_NAME
from RDB$RELATION_CONSTRAINTS RC
LEFT JOIN RDB$INDICES I ON
   (I.RDB$INDEX_NAME = RC.RDB$INDEX_NAME)
LEFT JOIN RDB$INDEX_SEGMENTS S ON
   (S.RDB$INDEX_NAME = I.RDB$INDEX_NAME)
WHERE (RC.RDB$CONSTRAINT_TYPE = 'PRIMARY KEY')
AND (I.RDB$RELATION_NAME = 'COUNTRY')
---根据表名得到其相关的依赖.
SELECT RDB$DEPENDENT_NAME AS DEPENDENT_NAME,
RDB$DEPENDED_ON_NAME AS DEPENDS_ON,
RDB$FIELD_NAME AS FIELD_NAME,
RDB$DEPENDENT_TYPE DEPENDENT_TYPE,
   CASE
    WHEN RDB$DEPENDENT_TYPE = 0 THEN 'TABLE'
    WHEN RDB$DEPENDENT_TYPE = 1 THEN 'VIEW'
    WHEN RDB$DEPENDENT_TYPE = 2 THEN 'TRIGGER'
    WHEN RDB$DEPENDENT_TYPE = 3 THEN 'COMPUTED'
    WHEN RDB$DEPENDENT_TYPE = 4 THEN 'VALIDATION'
    WHEN RDB$DEPENDENT_TYPE = 5 THEN 'PROCEDURE'
    WHEN RDB$DEPENDENT_TYPE = 6 THEN 'expression_r_INDEX'
    WHEN RDB$DEPENDENT_TYPE = 7 THEN 'EXCEPTION'
    WHEN RDB$DEPENDENT_TYPE = 8 THEN 'USER'
    WHEN RDB$DEPENDENT_TYPE = 9 THEN 'FIELD'
    WHEN RDB$DEPENDENT_TYPE = 10 THEN 'INDEX'
    WHEN RDB$DEPENDENT_TYPE = 14 THEN 'GENERATOR'
    ELSE 'UNKNOWN'
    END AS DEPENDENT_TYPE_STR,
   RDB$DEPENDED_ON_TYPE AS DEPEND_ON_TYPE,
   CASE
    WHEN RDB$DEPENDED_ON_TYPE = 0 THEN 'TABLE'
    WHEN RDB$DEPENDED_ON_TYPE = 1 THEN 'VIEW'
    WHEN RDB$DEPENDED_ON_TYPE = 2 THEN 'TRIGGER'
    WHEN RDB$DEPENDED_ON_TYPE = 3 THEN 'COMPUTED'
    WHEN RDB$DEPENDED_ON_TYPE = 4 THEN 'VALIDATIO