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

1 vote166 views1 answer
What is in condition in sql
SQL
5 votes169 views3 answers
Sql make column nullable
SQL
9 votes171 views4 answers
How to alter table column name in mysql
SQL
0 vote190 views1 answer
Pl/pgsql declare variable
SQL
1 vote159 views1 answer
Mysqli connect
SQL
5 votes159 views1 answer
Postgres integer to serial
SQL
1 vote283 views1 answer
Primary key reset in SQL database
SQL
0 vote146 views3 answers
Mysql calculate age from date of birth
SQL
61 votes1.2K views6 answers
Mysql add column
SQL
0 vote205 views1 answer
Truncate a table then insert data
SQL