原 所有数据库查询表和列的注释SQL汇总(Oracle、MySQL、PostgreSQL、GreenPlum、SQL Server)
Tags: Oracle原创PGGreenPlumMSSQLSQL ServerMySQLPostgreSQL注释
Oracle
参考:https://www.xmmup.com/oraclezhongduibiaohelietianjiazhushijichaxunzhushi.html
查询表的注释:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 | SELECT D.OWNER, D.TABLE_NAME, D.COMMENTS FROM DBA_TAB_COMMENTS D WHERE D.OWNER = 'LHR' AND D.COMMENTS IS NOT NULL; SELECT table_name, comments AS table_comment FROM all_tab_comments WHERE table_name = 'your_table_name' -- 替换为你的表名称 AND owner = 'your_schema_name'; -- 替换为你的模式名称 |
查询列的注释:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 | SELECT D.OWNER, D.TABLE_NAME,D.COLUMN_NAME, D.COMMENTS FROM DBA_COL_COMMENTS D WHERE D.OWNER = 'LHR' AND D.TABLE_NAME='CMMND_INFO_HSTRY' AND D.COMMENTS IS NOT NULL; SELECT table_name, column_name, comments AS column_comment FROM all_col_comments WHERE table_name = 'your_table_name' -- 替换为你的表名称 AND owner = 'your_schema_name'; -- 替换为你的模式名称 |
请确保将 "your_database_name"、"your_table_name"、"your_schema_name" 替换为你要查询的数据库、表和模式的实际名称。这些查询语句针对不同的数据库管理系统,可以帮助你查询表和列的注释信息。
示例
1 2 3 4 5 6 7 8 9 10 11 12 | CREATE TABLE employees ( employee_id NUMBER, first_name VARCHAR2(50), last_name VARCHAR2(50) ); COMMENT ON TABLE employees IS '员工信息表'; COMMENT ON COLUMN employees.employee_id IS '员工ID'; COMMENT ON COLUMN employees.first_name IS '员工名字'; COMMENT ON COLUMN employees.last_name IS '员工姓氏'; |