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 vote167 views2 answers
Sql auto update dupdated_at
SQL
23 votes176 views3 answers
Sql where contains part of string
SQL
8 votes188 views1 answer
Alter tablespace add datafile autoextend
SQL
0 vote174 views1 answer
Trigger vérifier stock
SQL
9 votes166 views3 answers
Oracle undo usage by session
SQL
-1 vote186 views5 answers
Operator in sql
SQL
0 vote191 views1 answer
Get only one row in mysql
SQL
0 vote173 views1 answer
R write csv without index
SQL
0 vote174 views1 answer
Look at running processes redshift
SQL
0 vote179 views1 answer
Copy data from one postgres container to another
SQL