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

15 votes181 views4 answers
Create table if not exists sql
SQL
0 vote159 views1 answer
Mysql select row with min date
SQL
1 vote165 views1 answer
Real world example of nosql
SQL
11 votes183 views1 answer
Sql insert multiple rows from select
SQL
2 votes178 views1 answer
Flask sqlalchemy boolean field
SQL
6 votes188 views3 answers
Update with inner join postgres
SQL
2 votes180 views1 answer
SQL IF ELSE
SQL
2 votes182 views2 answers
How to DROP a table in mysql
SQL
0 vote172 views1 answer
How to display value of variable in mysql
SQL
1 vote180 views3 answers
Coderbyte mysql challenge MySQL challenge, your query should return the informatioi for the employee with the third highest salary.
SQL