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 vote136 views1 answer
Oracle pl/sql check if file exists
SQL
-1 vote125 views1 answer
Utf8_encode mysql
SQL
17 votes133 views3 answers
How to change a collumn name in sql
SQL
2 votes119 views1 answer
Oracle sql drop column if exists
SQL
1 vote138 views1 answer
Spark sql convert string to date
SQL
0 vote136 views1 answer
For row in sql database python loop
SQL
0 vote123 views1 answer
Left join in codeigniter query builder
SQL
19 votes132 views6 answers
Mysql if null
SQL
0 vote135 views1 answer
What logs are available on RDS MySQL?
SQL
6 votes126 views3 answers
Check if string contains substring sql
SQL