Menu
The question title pretty much says it all.
What is the generic term for database tables, views, functions, stored procedures, et al?
Surely there is some term that can be used to describe these generically. Perhaps there is none, but I would have thought there would been a generally accepted industry term like "artifact" or "object".
EDIT: I'm not looking for the collective environmental term (i.e. a schema) or a term for the definitions of those objects (i.e. DDL scripts). I'm looking for a term that describes generically a database component, whether it be a table, view, function, etc.
985
A view is a database object that allows generating a logical subset of data from one or more tables. A table is a database object or an entity that stores the data of a database. The view depends on the table. The table is an independent data object.
A database table is also called a relation. Tables have rows and columns: A row is a database record, called a tuple; a column is called an attribute. A single cell (the intersection of a row and a column) in a database is called a value.
Tables are database objects that contain all the data in a database. In tables, data is logically organized in a row-and-column format similar to a spreadsheet. Each row represents a unique record, and each column represents a field in the record.
A stored procedure is a set of Structured Query Language (SQL) statements with an assigned name, which are stored in a relational database management system (RDBMS) as a group, so it can be reused and shared by multiple programs.
(imported from comments per OP's request)
I'm afraid "database objects/entities" is the best you can get.
167
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
