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 vote283 views1 answer
How to check xampp mysql password
SQL
13 votes317 views4 answers
What is sql
SQL
1 vote311 views1 answer
Altrer name column postgres
SQL
0 vote298 views1 answer
PDOException: SQLSTATE[HY093]: Invalid parameter numb
SQL
2 votes284 views2 answers
How to view created temporary tables in mysql
SQL
10 votes299 views3 answers
Sql select between two dates
SQL
0 vote312 views1 answer
Min:sec datediff mssql
SQL
0 vote302 views1 answer
How to print some string in mysql
SQL
0 vote276 views1 answer
Mysql money value
SQL
1 vote284 views1 answer
Create new table in SQL from old table with data
SQL