SELECT RDB$RELATION_NAME AS TABLE_NAME, list(trim(RDB$FIELD_NAME),',') AS COLUMNS
FROM RDB$RELATIONS
LEFT JOIN (SELECT * FROM RDB$RELATION_FIELDS ORDER BY RDB$FIELD_POSITION) USING (rdb$relation_name)
WHERE
(RDB$RELATIONS.RDB$SYSTEM_FLAG IS null OR RDB$RELATIONS.RDB$SYSTEM_FLAG = 0)
AND RDB$RELATIONS.rdb$view_blr IS null
GROUP BY RDB$RELATION_NAME
ORDER BY 1
如果要获取特定表中列名的列表,则需要以下sql查询:
我在firebird 2.5中试过这个,结果成功了。
顺便说一句,表名周围的单引号是必需的
获取所有表的列列表(逗号分隔,按位置排序):
相关问题 更多 >
编程相关推荐