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 vote321 views1 answer
List all functions and procedures in postgres query
SQL
1 vote318 views1 answer
Oracle case
SQL
0 vote291 views1 answer
Import sql mysql ubuntu
SQL
10 votes308 views1 answer
All_dependencies
SQL
0 vote311 views1 answer
Call function sql oracle
SQL
4 votes337 views1 answer
Alter session set nls_date_format
SQL
1 vote355 views2 answers
Sql server backup table
SQL
0 vote326 views1 answer
Select last N rows mysql
SQL
0 vote341 views1 answer
Calculate age in sql
SQL
0 vote302 views1 answer
Renommer table sql
SQL