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 vote150 views1 answer
Sql delete from with relation
SQL
3 votes139 views1 answer
Postgresql if null then 0
SQL
3 votes150 views2 answers
WhereIn SQL
SQL
2 votes180 views1 answer
Insert from table tsql
SQL
-1 vote151 views1 answer
Auto increment psql not primary key
SQL
1 vote338 views1 answer
Postgres upgrade to superuser
SQL
7 votes187 views4 answers
Mysql delete older duplicates
SQL
1 vote176 views2 answers
One to one and one to many relationship
SQL
0 vote159 views1 answer
Java check if something is in mysql table
SQL
2 votes159 views1 answer
Sqlserver: how to search a table used in particular stored procedure
SQL