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

7 votes310 views2 answers
What is sql clause
SQL
6 votes307 views2 answers
Mysql get yesterday
SQL
0 vote314 views1 answer
Sql count matching group by
SQL
0 vote303 views1 answer
MySQL get all previous date record
SQL
16 votes310 views2 answers
Sql exists
SQL
0 vote303 views1 answer
Enable full text search mysql
SQL
19 votes310 views6 answers
Sql server drop table if exists
SQL
2 votes292 views1 answer
Oracle table size
SQL
0 vote300 views1 answer
Java spring boot connect to sql server
SQL
0 vote295 views1 answer
Oracle sql winter time change
SQL