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 vote310 views1 answer
Mysql date without time
SQL
14 votes329 views5 answers
Set password for postgres user ubuntu
SQL
4 votes277 views1 answer
Sql query to make a existing column auto increment
SQL
0 vote241 views1 answer
Create bakupd database sqlserver
SQL
0 vote281 views1 answer
Mysql procedure between two tables
SQL
12 votes308 views2 answers
Insert multiple rows from another table sql
SQL
0 vote278 views1 answer
Check if table exists oracle
SQL
1 vote301 views1 answer
Mysql alter decimal precision
SQL
1 vote333 views1 answer
Oracle columns table
SQL
0 vote283 views1 answer
CALCULATING MONTHS BETWEEN TWO DATES IN POSTGRESQL
SQL