Search
 
SCRIPT & CODE EXAMPLE
 
CODE EXAMPLE FOR SQL

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';
 
PREVIOUS NEXT
Tagged: #commentaire #table #oracle
ADD COMMENT
Topic
Name
5+1 =