CODEWITHSUNDEEP
databaseterminology
e_i_pi
e_i_pi

Reputation: 4820

What is the generic term for database tables, views, functions, and stored procedures?

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.

Upvotes: 7

Views: 2521

Answers (4)

Sergio Tulentsev
Sergio Tulentsev

Reputation: 230276

(imported from comments per OP's request)

I'm afraid "database objects/entities" is the best you can get.

Upvotes: 6

Sumesh TG
Sumesh TG

Reputation: 2575

DBMS - This is the generic term for database , tables , triggers , procedures ... etc

Upvotes: 0

Pankaj Gadge
Pankaj Gadge

Reputation: 2814

Schema

In a relational database, the schema defines the tables, fields, relationships, views, indexes, packages, procedures, functions, queues, triggers, types, sequences, materialized views, synonyms, database links, directories, XML schemas, and other elements.

Source:

https://docs.oracle.com/cd/B19306_01/server.102/b14220/schema.htm

Upvotes: 0

Coxy
Coxy

Reputation: 8928

DDL - which is a TLA for either data definition language or data description language.

Upvotes: -2

Related Questions