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 vote234 views1 answer
Sql select merge multiple values
SQL
3 votes229 views2 answers
Funktion LOWER/UPPER sql
SQL
1 vote221 views2 answers
Sql convert datetime to year month
SQL
0 vote235 views1 answer
Except in sql alchemy
SQL
1 vote247 views1 answer
OstgreSQL version
SQL
10 votes236 views1 answer
Oracle dba_dependencies
SQL
0 vote219 views4 answers
Sql limit 1 offset 1
SQL
0 vote245 views1 answer
Is there any limit of using joins in single mysql query ?
SQL
1 vote256 views1 answer
How to get the date diff on once field in sql server
SQL
18 votes232 views6 answers
Drop table if exists
SQL