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

15 votes342 views2 answers
Select Options
SQL
0 vote372 views1 answer
Prodection ready postgres database step by step
SQL
0 vote330 views1 answer
Sqlserver now
SQL
16 votes406 views1 answer
Sqlserver add column to table
SQL
0 vote374 views1 answer
Login failed for user sql server
SQL
0 vote349 views2 answers
Plsql regex match whole word
SQL
0 vote420 views2 answers
SQL SERVER ORDER BY DATE NULL LAST
SQL
0 vote368 views1 answer
Sql select upcoming birthdays
SQL
0 vote338 views2 answers
Postgresql get long running queries
SQL
0 vote375 views1 answer
Mysql add to number
SQL