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
45%
21%
13%
11%
10%
Reviews
A
Arvind Kumar
5
very nice course for begginer to under stand
H
hemant
5
Hello sir, explaination is excellent. I have a request please send the db in excel or SQL file
J
Juboraj Juboraj
4
Explain details & easy to understand.
A
Aman Kanaujia
4
All good , but provide the data also for the assignment , Without data the interest is less day by day from the course. So, try to solve this problem as asap.
S
Snehil
4
Everything is good but keyboard sounds more harsh and overlap your voice whereas this course is best.
F
FAROOK MOHAMMAD
5
Hello sir, explaination is excellent. I have a request please send the db in excel or SQL file.
H
Hari Prakash
4
In SQL Join Function's 2nd video - Teacher's voice dose not match with background content that are plays
A
Aakash Mavar
5
Hello sir
Mera Abhi graduation hu he Mene Mechanical Engineering BTech ki Hai me Data analysis me Apna career Bana skat ho Kya
Share a personalized message with your friends.