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 vote268 views1 answer
Mysql check if lowercase
SQL
2 votes267 views1 answer
ADD COLOUNS CREATED AND UPDATED AT IN MYSQL
SQL
5 votes264 views1 answer
Oracle create table comment
SQL
0 vote245 views1 answer
How to Group by and concatenate arrays with all columns in PostgreSQL
SQL
16 votes248 views3 answers
Order by sql query
SQL
0 vote263 views1 answer
Postgresql not in alternative
SQL
1 vote288 views1 answer
Print year of a date sql
SQL
0 vote256 views1 answer
Mysql date time string format python
SQL
0 vote261 views1 answer
C# check if mysql query modified rows
SQL
0 vote294 views1 answer
Use mysql in java program
SQL