Provides detailed accounting of all tables found within the user/designer-created database
-contains (at least) all the attribute names and characteristics for each table in the system
-contains metadata—data about data
-sometimes described as “the database designer’s database” because it records the design decisions about tables and their structures
Data Definition Language (DDL)
Used to built data, define data types and data structure in a database.
-describes the records, fields, and "sets" making up the user Data Model
Data Manipulation Language (DML)
Is that of SQL, which is used to retrieve and manipulate data in a Relational database. Comprises the 'SQL-data change' statements, which modify stored data but not the schema or database objects
-have their functional capability organized by the initial word in a statement, which is almost always a verb. In the case of SQL, these verbs are:
SELECT
INSERT
UPDATE
DELETE
No comments:
Post a Comment