Total Page Preview: 000000000348
What are the basic type of SQL Command in English and Hindi
Types of SQL command in English
SQL commands can be broadly classified into four categories: Data Definition Language (DDL), Data Manipulation Language (DML), Data Control Language (DCL), and Transaction Control Language (TCL).
Below are some commonly used SQL commands with examples:
1-Data Definition Language (DDL) Commands:
DDL commands are used to create, modify, or delete database objects like tables, indexes, views, etc.
-
CREATE: It is used to create a new table in the database.
Example:
-
ALTER: It is used to modify the structure of an existing table.
Example:
-
DROP: It is used to delete a table or other database objects.
Example:
2-Data Manipulation Language (DML) Commands:
DML commands are used to manipulate the data stored in the database.
-
SELECT: It is used to retrieve data from one or more tables in the database.
Example:
-
INSERT: It is used to add new rows to a table in the database.
Example:
-
UPDATE: It is used to modify existing rows in a table in the database.
Example:
-
DELETE: It is used to remove rows from a table in the database.
Example:
3-Data Control Language (DCL) Commands:
DCL commands are used to manage user access and permissions.
-
GRANT: It is used to grant specific privileges to a user.
Example:
-
REVOKE: It is used to revoke previously granted privileges from a user.
Example:
4-Transaction Control Language (TCL) Commands:
TCL commands are used to manage transactions in the database.
-
COMMIT: It is used to permanently save the changes made in a transaction to the database.
Example:
-
ROLLBACK: It is used to undo the changes made in a transaction and restore the database to its previous state.
Example:
These are some commonly used SQL commands with examples. There are many other commands available in SQL that can be used to perform various database operations.
Types of SQL command in Hindi
SQL commands 4 prakar ke hote hain: Data Definition Language (DDL), Data Manipulation Language (DML), Data Control Language (DCL), aur Transaction Control Language (TCL).
Niche diye gaye hain kuch aam SQL commands ke saath examples:
1-Data Definition Language (DDL) Commands:
DDL commands ka upyog database ke objects jaise table, index, view, etc. ko create, modify, ya delete karne ke liye kiya jata hai.
-
CREATE: Ye database mein ek naya table create karne ke liye use hota hai.
Example:
-
ALTER: Ye ek maujooda table ke structure ko modify karne ke liye use hota hai.
Example:
-
DROP: Ye ek table ya kisi aur database object ko delete karne ke liye use hota hai.
Example:
2-Data Manipulation Language (DML) Commands:
DML commands ka upyog database mein store kiye gaye data ko manipulate karne ke liye kiya jata hai.
-
SELECT: Ye database mein se ek ya ek se adhik tables se data retrieve karne ke liye use hota hai.
Example:
-
INSERT: Ye database mein ek table mein naye rows ko add karne ke liye use hota hai.
Example:
-
UPDATE: Ye database mein ek table ke existing rows ko modify karne ke liye use hota hai.
Example:
-
DELETE: Ye database mein se ek table se rows ko remove karne ke liye use hota hai.
Example:
3-Data Control Language (DCL) Commands:
DCL commands ka upyog user access aur permissions ko manage karne ke liye kiya jata hai.
-
GRANT: Ye ek user ko specific privileges grant karne ke liye use hota hai.
Example:
-
REVOKE: Ye ek user se pehle diye gaye privileges ko revoke karne ke liye use hota hai.
Example:
4-Transaction Control Language (TCL) Commands:
TCL commands ka upyog database mein transactions ko manage karne ke liye kiya jata hai.
-
COMMIT: Ye ek transaction mein kiye gaye changes ko database mein permanently save karne ke liye use hota hai.
Example:
-
ROLLBACK: Ye ek transaction mein kiye gaye changes ko undo karne aur database ko pehle ke state mein restore karne ke liye use hota hai.
Example:
Ye kuch aam SQL commands hain jo commonly used hote hain. SQL mein aur bhi kayi commands available hote hain jinse various database operations perform kiye ja sakte hain.
Thank You
About Author
Brijesh Kumar
Database Developer
I have more then 6 years Experience in Microsoft Technologies - SQL Server Database, ETL
Azure Cloud - Azure SQL Database, CosmosDB, Azure Data Factory, PowerBI, Web Job, Azure Function, Azure Storage, Web Apps, Powershall
and Database Migration On-Premise to Azure Cloud.
LinkedIn : https://www.linkedin.com