DDL (Data Definition Language) instructions are used to create and change database objects.
Creates things.
Alters the state of objects.
Objects are deleted when you drop them.
Truncate: This command deletes all data in a table.
DROP is a Data Definition Language command, whereas DELETE is a Data Manipulation Language command. The difference between DELETE and DROP is that DELETE removes tuples from a table while DROP removes the entire schema, table, domain, or constraints from the database.
The DELETE command is used to remove rows from a table (one or more). This command is used to delete all of the rows in a table. 2. It's a DML command (Data Manipulation Language).
Learner's Ratings
3.8
Overall Rating
48%
17%
9%
17%
9%
Reviews
S
Swati Patil
5
Excellent
A
Avinash Rawat
4
I want to assignment answer and data. excellent teach
rawatavinash1995@gmail.com
P
Pravin Kashid
5
excellent teaching technique...one of the best course content...
Share a personalized message with your friends.