//查询所有表
SELECT RELNAME FROM sys_class WHERE RELKIND='r'
//查询某个模式下的所有表
SELECT A.RELNAME FROM sys_class A,sys_namespace B WHERE A.RELNAMESPACE = B.OID AND A.RELKIND='r' AND B.NSPNAME='模式名'
4.查询某个表的表元数据
SELECT
A.COLUMN_NAME as 字段名,
A.TYPE_NAME as 字段类型,
A.COLUMN_SIZE as 字段长度,
A.DECIMAL_DIGITS as 小数位数,
CAST((CASE WHEN A.NULLABLE=0 THEN 1 ELSE 2 END) as VARCHAR(500)) as 是否非空, --1:是 2:否
A.COLUMN_DEF as 默认值,
DECODE((SELECT COLUMN_NAME FROM v_sys_primary_keys B WHERE A.TABLE_SCHEM=B.TABLE_SCHEM AND A.TABLE_NAME=B.TABLE_NAME), A.COLUMN_NAME, 1, 2) as 是否主键, --1:是 2:否
A.REMARKS as 注释
FROM v_sys_columns A WHERE A.TABLE_SCHEM='模式名' AND A.TABLE_NAME='表名' AND A.ORDINAL_POSITION>=0