- 17.9K All Categories
- 3.4K Industry Applications
- 3.4K Intelligent Advisor
- 73 Insurance
- 537.3K On-Premises Infrastructure
- 138.6K Analytics Software
- 38.6K Application Development Software
- 6K Cloud Platform
- 109.6K Database Software
- 17.6K Enterprise Manager
- 8.8K Hardware
- 71.2K Infrastructure Software
- 105.3K Integration
- 41.6K Security Software
Extended Properties for schema objects
At the moment Oracle database allows developers to add a single Comment to tables, views, columns, as well as a handful of other object types.
SQL Server supports the concept of "Extended Properties" which allow unlimited name/value pairs to be added to almost any schema object including:
- Database (== Oracle schema, I believe)
- Stored Procedures
- User-defined Functions
- Table Column
- Table Index
"Extended Properties can be used to:
- Specify a caption for a table, view, or column.
- Specify a display mask for a column.
- Display a format of a column, define edit mask for a date column, define number of decimals, etc.
- Specify formatting rules for displaying the data in a column.
- Describe a specific database objects for all users."
I can think of other uses for this sort of thing as well, primarily to do with systematic markup of attributes to be used for automated code generation.
Of course, one could create a table and an API package to build something like this, and you'd then need a DDL trigger to detect dropped objects, etc. but it would be great to have this available as a builtin feature of the database.