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 vote426 views1 answer
Reindexing all tables sql server
SQL
0 vote367 views2 answers
Athena drop partition
SQL
6 votes452 views3 answers
What is where in sql
SQL
8 votes349 views2 answers
Mysql query dates between two dates
SQL
0 vote399 views1 answer
Postgresql print sessions using the database
SQL
0 vote359 views1 answer
Sp in sql server
SQL
4 votes346 views2 answers
Xampp mysql database server is not starting mac m1
SQL
0 vote371 views2 answers
Cambiar nombre tabla mysql
SQL
0 vote329 views1 answer
Create dabase postgresql
SQL
0 vote336 views1 answer
Difference between cross apply and inner join
SQL