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

0 vote310 views1 answer
Login failed for user sql server
SQL
0 vote300 views1 answer
Oracle temporary table
SQL
0 vote290 views1 answer
Mysql check datetime equals date
SQL
-1 vote305 views1 answer
Sql show custom constraints
SQL
0 vote276 views1 answer
SQL Server format datetime
SQL
-1 vote286 views2 answers
On update cascade
SQL
0 vote303 views1 answer
Configure MYSQL to run on another port number, other than the default port 3306 ubuntu linux
SQL
1 vote292 views2 answers
Restart identity cascade
SQL
0 vote323 views1 answer
Mysql case when on date
SQL
0 vote287 views1 answer
Sql server convert date to weekday
SQL