Which of the following is used to write database schema?

A database schema is the skeleton structure that represents the logical view of the entire database. SQL commands can be used to create a database schema.

SQL commands are divided into four subgroups, DDL, DML, DCL, and TCL.

DDL (Data Definition Language) statements are used for creating and defining the Database Schema.

Examples: CREATE, ALTER, DROP statements

While DML (Data Manipulation Language) statements are used for managing data within the Database.

Examples: SELECT, UPDATE, INSERT statements

DCL (Data Control Language) which includes commands that are mostly concerned with rights, permissions and other controls of the database system.

Example: GRANT, REVOKE

TCL (Transaction Control Language) deals with a transaction within a database.

Example: COMMIT, ROLLBACK