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

4 votes222 views1 answer
Mysql query first character
SQL
0 vote238 views1 answer
Sql cmd no truncate
SQL
2 votes229 views1 answer
Merge firstname and lastname in sql oracle
SQL
0 vote201 views1 answer
Install mysql 8 linux
SQL
0 vote217 views1 answer
Prepared statement mysql java delete selected rows
SQL
5 votes232 views2 answers
Mysqldump password
SQL
10 votes215 views2 answers
Reset mysql root password mac
SQL
40 votes213 views6 answers
Update table mysql
SQL
0 vote214 views1 answer
Add unique constraint sql server multiple columns
SQL
0 vote215 views1 answer
Retornar apenas o ano mysql date
SQL