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

5 votes102 views1 answer
Update sql user password
SQL
15 votes107 views1 answer
Mysql int range
SQL
1 vote106 views1 answer
Get table column names sql ssms
SQL
0 vote120 views1 answer
Find duplicate users by email address in mysql
SQL
0 vote112 views1 answer
Nosql vs sql
SQL
0 vote114 views1 answer
Mysql 8 geo to json
SQL
6 votes124 views2 answers
Sql sequence
SQL
3 votes116 views2 answers
Get current year sql
SQL
0 vote101 views1 answer
Sql clear table
SQL
2 votes111 views1 answer
Oracle table size
SQL