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 vote136 views1 answer
How to put value in parameters in mysqldataadapter
SQL
3 votes135 views2 answers
Mysql HAVING
SQL
0 vote137 views1 answer
Declare or use variable in snowflake
SQL
1 vote143 views2 answers
Insert sqlite
SQL
1 vote147 views1 answer
Postgres see sequence current state
SQL
8 votes134 views6 answers
Sql insert
SQL
16 votes137 views2 answers
Add column if not exists mysql
SQL
0 vote169 views1 answer
Sparql if bound query
SQL
19 votes141 views3 answers
How to change column type psql
SQL
0 vote139 views3 answers
Find below average salary in sql
SQL