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.5
Overall Rating
72%
17%
6%
0%
5%
Reviews
P
Priya Kushwaha
5
Very Good trainer
C
chanchal singh
5
you guys are doing nice job. thanks
U
Umesh Wankhede
5
Not too much interactive
M
Monesh Ram
5
Well Explained in Every Chapters..
G
GAJANAN DIGAMBAR MODE
5
very easy to understand SQL its was dream to learn SQL. Thanx for Learnvern
M
Mohmad Shadab
5
BEST VIDEOS
N
NAGASWETHA
5
very useful
M
mohd aamir
4
Hi Team,
Why you didn't teach/learn how to write select query, even you shared 15 question for practice :(
Y
Yashvant Kadwe
5
I have found the course to be interesting with plenty of valuable information provided as part of the course and through interaction with fellow teachers and trainers from a wide range of disciplines
Share a personalized message with your friends.