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 vote258 views2 answers
Postgres another version
SQL
10 votes247 views1 answer
All_dependencies
SQL
2 votes258 views1 answer
Find all triggers in database
SQL
0 vote233 views1 answer
Dump only schema
SQL
0 vote252 views1 answer
Sql find table by name
SQL
0 vote243 views1 answer
Mod function example
SQL
0 vote272 views1 answer
ORA-13717
SQL
2 votes275 views2 answers
Mysql add hours to time field
SQL
0 vote284 views1 answer
Work around for mutating problem in Oracle Triggers. Please check it out.
SQL
0 vote254 views1 answer
Sqlalchemy sequence postgresql
SQL