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

4 votes337 views1 answer
Oracle show errors compilation
SQL
0 vote407 views1 answer
Min varias colunas spark sql
SQL
0 vote341 views1 answer
Jdbc sql connection string
SQL
0 vote360 views1 answer
Teller stamp , bmo , PDF
SQL
1 vote328 views1 answer
Index a database column sql
SQL
1 vote338 views1 answer
How to truncate a table in databse
SQL
0 vote355 views1 answer
Shell script to log mysql cpu usage
SQL
0 vote344 views1 answer
Services.AddDbContext DataSource Sqlite
SQL
0 vote342 views1 answer
Get only structure database mysql
SQL
2 votes410 views1 answer
Cannot return non-composite value from function that returns composite type
SQL