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

15 votes368 views7 answers
MYSQL
SQL
0 vote361 views1 answer
Create schema sql server
SQL
17 votes417 views4 answers
Show all tables in oracle
SQL
0 vote368 views1 answer
Calculate age in sql
SQL
15 votes377 views4 answers
Mysql where value is null
SQL
1 vote359 views1 answer
Python escape mysql
SQL
0 vote346 views1 answer
Oracle drop default value
SQL
1 vote363 views1 answer
Woocommerce mysql price table
SQL
2 votes326 views1 answer
Plsql left() function
SQL
2 votes468 views2 answers
SQLSTATE[HY000] [1698] Access denied for user 'root'@'localhost' (SQL: select * from information_schema.tables where table_schema = laravel and table_name = migrations and table_type = 'BASE TABLE')
SQL