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

3 votes372 views2 answers
Truncate table
SQL
1 vote314 views1 answer
Mysql2::Error: Incorrect string value: '\xE2\x80\x8B
SQL
13 votes318 views2 answers
Check if value is null mysql
SQL
0 vote383 views1 answer
Mysql streaming example
SQL
3 votes307 views2 answers
Mysql add 2 hours
SQL
0 vote344 views1 answer
Change filed order in mysql
SQL
0 vote332 views1 answer
Less than date query sqlachemy
SQL
5 votes322 views1 answer
Oracle columns in all_tables
SQL
8 votes341 views1 answer
Today minus 15 days postgresql
SQL
1 vote281 views1 answer
Mysql see column types
SQL