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

0 vote281 views1 answer
How to check default value of column in sql server
SQL
65 votes514 views6 answers
Sql add column to table
SQL
0 vote239 views1 answer
Microsoft sql server management studio clear cache
SQL
0 vote286 views1 answer
Oracle search columns in schema
SQL
11 votes318 views3 answers
Sql line numbers
SQL
0 vote290 views1 answer
Postgres enumerated type
SQL
0 vote277 views1 answer
MySql count occurences more than"
SQL
13 votes320 views5 answers
Alter table query sql server change column
SQL
3 votes301 views3 answers
Sql last week
SQL
0 vote305 views1 answer
Ajouter une contrainte de clé étrangère sql
SQL