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

2 votes196 views1 answer
How to make multiple keys as primary in bdms
SQL
4 votes180 views1 answer
Force drop all tables postgres
SQL
1 vote192 views1 answer
Search for tables with name postgresql
SQL
6 votes177 views4 answers
Eloquent to sql with bindings
SQL
0 vote168 views1 answer
Postgresql certain first 4 characters in string
SQL
0 vote180 views1 answer
Java input type sql date
SQL
1 vote191 views2 answers
Mysql update table from another table
SQL
8 votes209 views2 answers
How to fetch data from database without last column
SQL
6 votes259 views3 answers
[2021-10-05T13:43:48.961Z] error Error: ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client
SQL
0 vote185 views1 answer
Mysql_error replacement
SQL