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

0 vote126 views1 answer
FIND LOWEST SALARY EARNER IN SQL
SQL
-1 vote111 views3 answers
Unknown collation: 'utf8mb4_0900_ai_ci'
SQL
1 vote137 views2 answers
Postgres select from last 3 months
SQL
1 vote111 views2 answers
Setval max id postgresql sequence
SQL
3 votes116 views2 answers
Postgresql remove not null constraint
SQL
1 vote111 views1 answer
Oracle convert run duration to number
SQL
-1 vote126 views1 answer
Default username and password for oracle 11g
SQL
1 vote130 views3 answers
Postgresql get difference between two dates
SQL
2 votes112 views1 answer
Alter table add multiple columns postgresql
SQL
0 vote136 views1 answer
Connect laravel to mysql on mac
SQL