Alter table add comment oracle

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 vote107 views1 answer
Query params sql insert python f string
SQL
3 votes103 views2 answers
Oracle sql drop sequence
SQL
1 vote96 views1 answer
Setval pgsql
SQL
0 vote98 views1 answer
Mysql DDL
SQL
0 vote116 views1 answer
Oracle list user locked
SQL
0 vote104 views1 answer
Oracle character index
SQL
0 vote93 views1 answer
Is numeric in sql
SQL
4 votes101 views2 answers
Oracle last day of month
SQL
3 votes99 views1 answer
Oracle sleep
SQL
0 vote107 views1 answer
Every Derived yable must have its own alias
SQL