patternMinor
Complete list of possible database "objects"?
Viewed 0 times
objectsdatabasecompletepossiblelist
Problem
When I finished my degree in Programming and Database I remember there being a general list of database "objects" like this:
Have there been any additions to this list since then?
- data types (a list unto itself)
- fields
- records
- tables
- views (sort of like stored queries you can re-run)
- relations between tables (foreign keys)
- transactions (not really an object but something in the database)
- connections
- users
- groups
- permissions
- triggers
- stored procs
Have there been any additions to this list since then?
Solution
Some more:
- domains
- synonyms
- sequences
- rules
- constraints
- assertions (though I don't know of any DBMS supporting them)
- indexes
- roles
- user defined (object) types
Context
StackExchange Database Administrators Q#19985, answer score: 4
Revisions (0)
No revisions yet.