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 vote160 views1 answer
How to select only id where is not in column mysql
SQL
2 votes167 views1 answer
Oracle sql drop table purge
SQL
0 vote165 views1 answer
Oracle enable chain
SQL
0 vote176 views1 answer
Select last 2 characters sql
SQL
1 vote171 views1 answer
Multiple count in sql
SQL
13 votes205 views3 answers
Mysqldump structure only
SQL
5 votes181 views3 answers
Oracle first day of last year
SQL
0 vote176 views1 answer
How to insert a uniqueidentifier in sql
SQL
1 vote173 views1 answer
Oracle extract minute from date
SQL
1 vote168 views2 answers
Create a unqie constraint mysql
SQL