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
4.3
Overall Rating
72%
10%
7%
0%
11%
Reviews
A
Abhishek vishwkarma
5
kya SQL ke liye MYSQL use kar sakte hai ya koi specific server hi use karna hoga
V
Vishnu Suvaliya
5
Forums.learnvern.com cant work
A
Ankush Raj
5
good
R
ruhina qureshi
5
Awesome Classes ,Both tutors explains the concept very nice
Y
Yadav Aakash
5
very useful thank you learnvern
A
Ashish
5
The course is very good. I have stuck at a point that how you create multiple rows with a single insert in sales.customer table. I get only one customer data. this table is related to bikestore data.
Share a personalized message with your friends.