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

3 votes302 views2 answers
Update part of a string in mysql
SQL
0 vote295 views2 answers
Script all indexes in a database
SQL
0 vote236 views1 answer
Mysql find foreign key references
SQL
0 vote260 views1 answer
How to update rows from a table when certain conditions are met in mysql
SQL
0 vote273 views1 answer
Syntax for changing column size in mysql
SQL
5 votes259 views2 answers
Update all rows mysql
SQL
6 votes290 views2 answers
Postgresql pg_dump
SQL
0 vote268 views1 answer
Concat column value of same user in mysql
SQL
11 votes301 views2 answers
How to import mysql database command line
SQL
-1 vote264 views1 answer
Mysql coalesce
SQL