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

57 votes297 views6 answers
Sql alter table
SQL
0 vote122 views1 answer
Mariadb datetime change to microseconds
SQL
1 vote198 views1 answer
Truncate table in postgresql and reset id
SQL
4 votes121 views2 answers
Tsql utf to local time
SQL
0 vote143 views2 answers
Sql query print strings and int
SQL
1 vote121 views1 answer
Sql get all columns from one table but one from another inner join
SQL
0 vote122 views2 answers
Postgres default user
SQL
3 votes132 views1 answer
Sql is not like
SQL
0 vote118 views1 answer
Get sum sqlite android
SQL
0 vote138 views1 answer
Postgresql import data from csv
SQL