Oracle create table comment

COMMENT ON TABLE table_name IS 'A table comment';
COMMENT ON COLUMN table_name.MY_COLUMN IS 'A column comment';

SELECT * FROM ALL_TAB_COMMENTS WHERE TABLE_NAME = 'TABLE_NAME';
SELECT * FROM ALL_COL_COMMENTS WHERE TABLE_NAME = 'TABLE_NAME';

Similar codes

2 votes291 views1 answer
Convert series number to date in sql
SQL
0 vote300 views1 answer
Select from 3 tables one is empty
SQL
0 vote394 views1 answer
How to check foreign key constraint in sql
SQL
2 votes324 views1 answer
Query any digits record
SQL
0 vote314 views3 answers
Sql all columns
SQL
11 votes323 views1 answer
Get ddl materialized view oracle
SQL
1 vote325 views4 answers
Aggregate function in sql
SQL
18 votes301 views2 answers
Sql inner join
SQL
19 votes316 views2 answers
Mysql tinyint max value
SQL
5 votes362 views1 answer
Oracle drop index if exists
SQL