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

1 vote279 views1 answer
Metada in sql
SQL
0 vote308 views1 answer
Sqlalchemy get ids
SQL
2 votes282 views1 answer
Foreign key example in dbms
SQL
0 vote349 views1 answer
Time data type in mysql
SQL
18 votes291 views4 answers
Foreign key mySql
SQL
1 vote304 views1 answer
Check constraint to check if date greater than todays date
SQL
0 vote336 views1 answer
Create a sql server database programmatically
SQL
5 votes295 views1 answer
Oracle list packages
SQL
0 vote350 views1 answer
Mysql order by rand limit 1 really slow
SQL
1 vote321 views2 answers
Insert sqlite
SQL