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

10 votes145 views2 answers
Show tables in schema oracle
SQL
1 vote136 views1 answer
Mysql random limit 1
SQL
0 vote160 views1 answer
Postgres change the name of schema
SQL
13 votes133 views2 answers
Sql count distinct group by
SQL
0 vote140 views1 answer
Mysql multiple primary keys
SQL
1 vote146 views1 answer
Sample in sql
SQL
1 vote137 views1 answer
Crontab every month
SQL
0 vote146 views2 answers
Which MySQL statement is used to delete data from a database
SQL
0 vote138 views2 answers
Pl sql auto increment
SQL
3 votes159 views3 answers
1396(hy00) mysql error
SQL