2,208
社区成员
发帖
与我相关
我的任务
分享怎样知道interbase数据库中包含的数据表的数量和名称？
我在程序应用中需要知道某一interbase数据库中的数据表的名称和数量，怎样获取interbase数据库中包含的数据表的数量和名称？
...全文
请发表友善的回复…
发表回复
jasonwjk 2003-07-09
- 打赏
- 举报
或者通过Delphi中的Connection也可以获得
jasonwjk 2003-07-09
- 打赏
- 举报
To extract non-system tables (and no views):
SELECT RDB$RELATION_NAME
FROM RDB$RELATIONS
WHERE ((RDB$SYSTEM_FLAG = 0) OR
(RDB$SYSTEM_FLAG IS NULL)) AND
(RDB$VIEW_SOURCE IS NULL)
ORDER BY RDB$RELATION_NAME
To extract system tables (no user defined tables):
SELECT RDB$RELATION_NAME
FROM RDB$RELATIONS
WHERE (RDB$SYSTEM_FLAG = 1) AND
(RDB$VIEW_SOURCE IS NULL)
ORDER BY RDB$RELATION_NAME
To extract all of the above information:
SELECT RDB$RELATION_NAME
FROM RDB$RELATIONS
WHERE (RDB$VIEW_SOURCE IS NULL)
ORDER BY RDB$RELATION_NAME
SELECT RDB$RELATION_NAME
FROM RDB$RELATIONS
WHERE ((RDB$SYSTEM_FLAG = 0) OR
(RDB$SYSTEM_FLAG IS NULL)) AND
(RDB$VIEW_SOURCE IS NULL)
ORDER BY RDB$RELATION_NAME
To extract system tables (no user defined tables):
SELECT RDB$RELATION_NAME
FROM RDB$RELATIONS
WHERE (RDB$SYSTEM_FLAG = 1) AND
(RDB$VIEW_SOURCE IS NULL)
ORDER BY RDB$RELATION_NAME
To extract all of the above information:
SELECT RDB$RELATION_NAME
FROM RDB$RELATIONS
WHERE (RDB$VIEW_SOURCE IS NULL)
ORDER BY RDB$RELATION_NAME
