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 vote234 views1 answer
How to create a new shema using query languaage
SQL
2 votes278 views1 answer
Sql string starts with
SQL
0 vote227 views1 answer
Sql roll up rows into columns
SQL
2 votes240 views1 answer
How to insert string variable into sqlite database
SQL
-1 vote200 views1 answer
Oracle db list usernames
SQL
-1 vote234 views2 answers
Sql convert date to string yyyy-mm-dd
SQL
1 vote243 views1 answer
Sql not equal multiple columns
SQL
1 vote227 views1 answer
Postgres regex remove special characters
SQL
7 votes244 views2 answers
Sql empty table
SQL
3 votes240 views1 answer
Select count from table mysql
SQL