Oracle create table comment

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 votes169 views1 answer
Datepart postgres
SQL
0 vote179 views1 answer
Jenkins SQLCMD run
SQL
0 vote207 views1 answer
Repeatable read trong sql server
SQL
0 vote194 views1 answer
Oracle execute immediate quotes
SQL
2 votes171 views1 answer
Sql update alias
SQL
1 vote190 views1 answer
Change default maximum runtime mariadb from phpmyadmin
SQL
7 votes189 views3 answers
Foreign key oracle
SQL
7 votes202 views6 answers
Mysql group concat
SQL
1 vote186 views1 answer
Select users with same username
SQL
0 vote183 views1 answer
Null column as zero in mysql
SQL