List few commands of DDL DML and DCL

+1 vote
Hi!!

Can someone list few commands of DML, DCL, & DDL?
Nov 12, 2018 in Database by DataKing99
• 8,240 points
94,302 views

2 answers to this question.

+1 vote

The list of commands is as follows: 

Data Definition Language (DDL) commands:

  • CREATE to create a new table or database.
  • ALTER for alteration.
  • Truncate to delete data from the table.
  • DROP to drop a table.
  • RENAME to rename a table.

Data Manipulation Language (DML) commands:

  • INSERT to insert a new row.
  • UPDATE to update an existing row.
  • DELETE to delete a row.
  • MERGE for merging two rows or two tables.

Data Control Language (DCL) commands:

  • COMMIT to permanently save.
  • ROLLBACK to undo the change.
  • SAVEPOINT to save temporarily.
answered Nov 12, 2018 by Sahiti
• 6,380 points
What you have written as DCL is infact TCL. DCL is used for granting permissions to users for maintaining sessions. Eg commands: GRANT, REVOKE.

TCL is used for transaction control. Eg: ROLLBACK,COMMIT,SAVEPOINT

Hello,

You can go through this:https://www.studytonight.com/dbms/dcl-command.php for better concept

–1 vote

Data Definition Language (DDL) commands:

  • CREATE to create a new table or database.
  • ALTER for alteration.
  • Truncate to delete data from the table.
  • DROP to drop a table.
  • RENAME to rename a table.

Data Manipulation Language (DML) commands:

  • INSERT to insert a new row.
  • UPDATE to update an existing row.
  • DELETE to delete a row.
  • MERGE for merging two rows or two tables.

Data Control Language (DCL) commands:

  • COMMIT to permanently save.
  • ROLLBACK to undo the change.
  • SAVEPOINT to save temporarily.
answered Dec 18, 2020 by Abdul
• 140 points
Commit , Rollback , Savepoint are TCL (TRANSACTION CONTROL LANGUAGE) commands and DCL commands are  GRANT AND REVOKE

Related Questions In Database

0 votes
2 answers

Advantages and Disadvantages of Stored Procedure

https://www.quora.com/What-are-the-advantages-of-using-an-SQL-store ...READ MORE

answered Apr 29, 2019 in Database by anonymous
16,439 views
0 votes
1 answer

What are the ways of Data Import and Export in MySQL Workbench?

There are majorly three ways to export ...READ MORE

answered Dec 14, 2018 in Database by DataKing99
• 8,240 points
1,594 views
0 votes
1 answer

Query to list number of records in each table in a database

Use the below code to list number of ...READ MORE

answered Oct 11, 2019 in Database by Omaiz
• 560 points
719 views
0 votes
1 answer

How to calculate age (in years) based on Date of Birth and getDate()

Following can be a solution to your ...READ MORE

answered Feb 23 in Database by Vaani
• 7,020 points
279 views
0 votes
1 answer

What are DDL and DML?

SQL Commands have subcategories like DDL, DML, DCL ...READ MORE

answered Feb 8 in Database by Vaani
• 7,020 points
224 views
0 votes
1 answer

What is DDL interpreter?

DDL Interpreter interprets the DDL statements and ...READ MORE

answered Nov 8, 2018 in Database by DataKing99
• 8,240 points
3,123 views
0 votes
1 answer

What are DDL and DML?

DDL DML DDL stands for Data Definition Language. DML stands ...READ MORE

answered Jun 1 in Others by Sohail
• 2,960 points
93 views
0 votes
0 answers

What are DDL and DML?

What are they and how do they ...READ MORE

Jun 9 in Others by polo
• 1,480 points
71 views
0 votes
1 answer

List all the types of user-defined functions

There are three types of user-defined functions, ...READ MORE

answered Oct 29, 2018 in Database by Sahiti
• 6,380 points
812 views
0 votes
1 answer

What do ‘Record’, ‘Field’ and ‘Table’ mean in terms of a database?

You can refer to the following definitions ...READ MORE

answered Nov 12, 2018 in Database by Sahiti
• 6,380 points
10,473 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP