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 votes311 views2 answers
Sqlite show table structure
SQL
3 votes296 views2 answers
Install mysql powershell
SQL
1 vote288 views1 answer
Oracle drop chain step
SQL
0 vote234 views1 answer
Finish transaction sql
SQL
0 vote290 views1 answer
Mysql match in serialized data
SQL
0 vote306 views1 answer
Sqlalchemy empty table
SQL
0 vote280 views1 answer
Display first three characters sql
SQL
1 vote296 views1 answer
ORA-01950
SQL
2 votes292 views1 answer
Oracle run_duration average
SQL
2 votes325 views3 answers
Xampp mysql database not starting
SQL