KingBase V8R6 SQL

Table of contents

1. KingBase 查表和注释
2. KingBase 查表字段注释

---

KingBase 查表和注释

SELECT col.COLUMN_NAME, col.data_type, col.UDT_NAME, d.DESCRIPTION, col.IS_NULLABLE,s.CONTYPE,col.table_schema,col.ordinal_position
FROM information_schema.COLUMNS col
         JOIN SYS_CLASS c ON c.RELNAME = col.TABLE_NAME
         LEFT JOIN SYS_DESCRIPTION d ON d.OBJOID = c.OID AND d.OBJSUBID = col.ORDINAL_POSITION
         LEFT JOIN sys_constraint s on c.OID = s.conrelid and col.ORDINAL_POSITION=ANY(conkey::int[])
WHERE
     col.table_catalog = 'bp_dev'
     and col.table_schema = 'public'
  AND  col.TABLE_NAME = 'mm_bad_debts';

KingBase 查表字段注释

SELECT col.COLUMN_NAME, col.data_type, col.UDT_NAME, d.DESCRIPTION, col.IS_NULLABLE,s.CONTYPE,col.table_schema,col.ordinal_position
FROM information_schema.COLUMNS col
         JOIN SYS_CLASS c ON c.RELNAME = col.TABLE_NAME
         LEFT JOIN SYS_DESCRIPTION d ON d.OBJOID = c.OID AND d.OBJSUBID = col.ORDINAL_POSITION
         LEFT JOIN sys_constraint s on c.OID = s.conrelid and col.ORDINAL_POSITION=ANY(conkey::int[])
WHERE
     col.table_catalog = 'bp_dev'
     and col.table_schema = 'public'
  AND  col.TABLE_NAME = 'mm_bad_debts';