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 vote198 views1 answer
Get who is hired in specific month in sql
SQL
0 vote219 views2 answers
Disallowed function mysql to_date()
SQL
0 vote204 views1 answer
Oracle sql alter view add column
SQL
0 vote201 views1 answer
Dump multiple tables mysql
SQL
2 votes188 views1 answer
Convert series number to date in sql
SQL
0 vote226 views1 answer
Group by 15 minute interval sql server
SQL
1 vote198 views1 answer
Create temporal table in sql
SQL
0 vote203 views1 answer
Sql put two columns into one
SQL
3 votes193 views2 answers
How to View column names of a table in SQL
SQL
0 vote210 views3 answers
Remove folders from remote git
SQL