HiveBrain v1.2.0
Get Started
← Back to all entries
patternMinor

Complete list of possible database "objects"?

Submitted by: @import:stackexchange-dba··
0
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:

  • 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.