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

8 votes144 views1 answer
Ltrim sql
SQL
32 votes156 views6 answers
Insert into values select
SQL
0 vote178 views1 answer
Sql alter column name sql server
SQL
0 vote137 views1 answer
Dump only schema
SQL
3 votes209 views1 answer
Apex call duration
SQL
0 vote105 views2 answers
Postgresql could not start server mac
SQL
0 vote150 views1 answer
Apex for oracle 11g
SQL
1 vote146 views1 answer
Sql how to duplicate a table
SQL
1 vote150 views3 answers
Sql union
SQL
0 vote136 views1 answer
How to get initials in sql
SQL