Commentaire table oracle

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 vote64 views1 answer
Mysql select top 2
SQL
0 vote221 views1 answer
Sql server query all database objects
SQL
0 vote111 views1 answer
Mysql date equals to current_date plus days
SQL
1 vote111 views1 answer
Minus vs intersect in sql
SQL
0 vote110 views2 answers
How to add CHECK constraint to a column in postgres
SQL
2 votes92 views1 answer
Postgresql change value in column
SQL
14 votes114 views2 answers
Oracle add attribute to table
SQL
2 votes113 views1 answer
Create delete procedure mysql
SQL
-1 vote103 views3 answers
Create temp table in sql
SQL
0 vote97 views1 answer
Django how to get query result count
SQL