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

2 votes172 views1 answer
Show max_allowed_packet mysql
SQL
0 vote158 views1 answer
Mysql conf.d exampel
SQL
0 vote146 views1 answer
Change magento database url usimg musql
SQL
1 vote200 views1 answer
Sql server delete top 1000
SQL
3 votes137 views1 answer
Oracle undo tablespace list by user
SQL
9 votes152 views5 answers
Laravel to sql
SQL
0 vote132 views1 answer
Mysql import datetime YYYY-MM-DDThh:mm:ss.000000Z
SQL
5 votes138 views3 answers
Sql make column nullable
SQL
0 vote136 views2 answers
Pl sql auto increment
SQL
0 vote254 views1 answer
How to delete duplicate rows in oracle
SQL