A database language concerned with the definition of the whole databas...
The database language concerned with the definition of the whole database structure and schema is DDL (Data Definition Language).
DDL (Data Definition Language) is a subset of SQL (Structured Query Language) that is used to define and manage the structure of a database. It allows users to create, modify, and delete database objects such as tables, views, indexes, and constraints.
Some key points about DDL include:
- It is used to define the structure of the database, including the tables, columns, data types, relationships, and constraints.
- DDL statements do not manipulate or retrieve data, but rather define the structure and organization of the database.
- DDL statements include CREATE, ALTER, and DROP statements.
- CREATE statement is used to create new database objects like tables, views, and indexes.
- ALTER statement is used to modify the structure of existing database objects.
- DROP statement is used to delete or remove database objects.
Examples of DDL statements:
- CREATE TABLE: Used to create a new table in the database.
- ALTER TABLE: Used to modify the structure of an existing table.
- DROP TABLE: Used to delete a table from the database.
In summary, DDL is the database language that is concerned with defining and managing the structure of the database, including creating, modifying, and deleting database objects.
To make sure you are not studying endlessly, EduRev has designed Class 8 study material, with Structured Courses, Videos, & Test Series. Plus get personalized analysis, doubt solving and improvement plans to achieve a great score in Class 8.