Oracle create table comment

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 vote179 views1 answer
EnvironmentError: mysql_config not found
SQL
5 votes197 views4 answers
SQL Order of execution
SQL
6 votes223 views3 answers
Psql show columns of table
SQL
0 vote175 views1 answer
Cast for print sql
SQL
1 vote194 views1 answer
Mysql curdate between two dates
SQL
0 vote173 views1 answer
Postgressql uuid
SQL
5 votes177 views4 answers
Restart the psql server windows
SQL
1 vote173 views1 answer
Psql client write to bash variable
SQL
5 votes190 views2 answers
Sql number columns
SQL
19 votes183 views6 answers
Mysql if null
SQL