I'm new to Oracle databases. I have used to SQL Server and the description fields (MS_Description) for tables and columns for documentation purposes. Is there an equivalent for Oracle? What is the best practice for documenting Oracle database?
How to document Oracle database
documentationmetadataoracle
Best Answer
In Oracle, you would use the COMMENT command to:
Most tools (PL/SQL Developer, Toad...) will display these comments in appropriate fields when you browse the database schema.
The comments can be queried directly with the
*COMMENTS
dictionary views, such asALL_TAB_COMMENTS
.