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

1 vote95 views2 answers
Mysql trim whitespace
SQL
0 vote110 views1 answer
Sql include rows with 0 values
SQL
0 vote113 views1 answer
Sql server union if table exist
SQL
0 vote93 views1 answer
Select other columns with distinct
SQL
4 votes100 views2 answers
Select first and last row mysql
SQL
0 vote122 views1 answer
Selecting all columns from table sql database
SQL
0 vote108 views1 answer
Can sqldatareader be null
SQL
-1 vote100 views1 answer
Io
SQL
-1 vote106 views1 answer
How to change the auto increment in existing table mysql
SQL
0 vote99 views1 answer
Inserting data into different tables at once in oracle sql
SQL