|
|
COMMENT
Add a comment to the data dictionary:
Syntax:
COMMENT ON TABLE [schema.]table IS 'text' COMMENT ON TABLE [schema.]view IS 'text' COMMENT ON TABLE [schema.]snapshot IS 'text' COMMENT ON COLUMN [schema.]table.column IS 'text' COMMENT ON COLUMN [schema.]view.column IS 'text' COMMENT ON COLUMN [schema.]snapshot.column IS 'text'
To drop a comment from the database, set it to the empty
string ' '.
You can view comments by querying the data dictionary views listed below.
"Don't let it end like this. Tell them I said something" - last words of
Pancho
Villa
Related Commands:
CREATE TABLE
SQL Plus REM statements
Related Views:
COL DICTIONARY DICT_COLUMNS DBA_COL_COMMENTS ALL_COL_COMMENTS USER_COL_COMMENTS DBA_TAB_COMMENTS ALL_TAB_COMMENTS USER_TAB_COMMENTS