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 vote171 views1 answer
H2 auto increment and unique
SQL
0 vote175 views1 answer
Default value false mysql
SQL
20 votes187 views6 answers
Creating a table in sql
SQL
16 votes176 views2 answers
Add column if not exists mysql
SQL
0 vote192 views1 answer
MySql shutdown unexpectedly InnoDB: Mutexes and rw_locks use Windows interlocked functions InnoDB: Uses event mutexes
SQL
0 vote175 views1 answer
Power bi find all ids not in other tables
SQL
10 votes170 views5 answers
Between keyword in sql
SQL
0 vote166 views1 answer
Sql datediff db2
SQL
4 votes223 views1 answer
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.s
SQL
0 vote133 views1 answer
Raven ql select count
SQL