Advertisements
Advertisements
Question
Explain the DDL command of their functions in SQL.
Solution
SQL- Structured Query Language is a standard language used for accessing and manipulating databases. It is declared as standard by American National Standards Institute (ANSI) and International Organization for Standardization (ISO) in 1986 and 1987 respectively.
Types of SQL Commands Different SQL commands are available to perform various functions. SQL commands are classified into five major categories depending on their functionality.
- Data Definition Language (DDL)
The DDL commands are used to define the database schema (Structure). Also to create and modify the structure of the database object in the database. CREATE, ALTER, DROP, RENAME and TRUNCATE commands belongs to this category.
SQL DDL COMMANDS List
| Commands | Description |
| CREATE | Used to create database or tables |
| ALTER | Modifies the existing structure of database or table |
| DROP | Deletes a database or table. |
| RENAME | used to rename an existing object in the database |
| TRUNCATE | Used to delete all table records |
APPEARS IN
RELATED QUESTIONS
Communication is established with MySQL using ______.
Which is the MySQL instance responsible for data processing?
List any two DDL commands with its Syntax.
List any two DML commands with its Syntax.
What is view in SQL?
Which commands provide definitions for creating table structure, deleting relations, and modifying relation schemas.
Which command lets to change the structure of the table?
Queries can be generated using ______
What is the difference between SQL and MySQL?
Write few commands used by DBA to control the entire database.
