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 vote286 views1 answer
Cannot define PRIMARY KEY constraint on nullable column in table 'Student'.
SQL
0 vote174 views1 answer
Set engine to innodb
SQL
0 vote166 views1 answer
Mariadb LOAD DATA INFILE
SQL
0 vote171 views1 answer
Microsoft word insert sql code
SQL
0 vote182 views1 answer
Function sum(text) does not exist postgres
SQL
-1 vote152 views1 answer
Mysql if example
SQL
0 vote175 views4 answers
Best data type to represent money in mysql
SQL
2 votes190 views4 answers
Sql query interview questions
SQL
0 vote204 views1 answer
Add new column in sql with foreign key
SQL
0 vote173 views1 answer
Time mysql w3
SQL