Alter table add comment 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 vote162 views1 answer
Postgresql can you have null foreign key
SQL
11 votes140 views2 answers
Having clause
SQL
0 vote175 views2 answers
Create-toys-table-with-toy_name-column
SQL
61 votes1K views6 answers
Mysql add column
SQL
1 vote174 views1 answer
Postgres install unaccent extension
SQL
0 vote153 views1 answer
Horizontal join sqlite
SQL
0 vote158 views1 answer
Create user faunadb
SQL
6 votes143 views2 answers
Find mysql version linux
SQL
0 vote166 views1 answer
Remove transient options sql wordpress
SQL
0 vote147 views1 answer
Implizite joins sql
SQL