Aniruddha Chourasia
Last answered:

28 Nov 2022

 Posted on:

23 Nov 2022
0

Resolved: DROP, RENAME and TRUNCATE

in SQL / Data definition language (DDL)

DROP, RENAME and TRUNCATE statements are to be used in combination with ALTER statement right?

1 answers ( 1 marked as helpful)
Tsvetelin Tsonkov
Instructor
Posted on:

28 Nov 2022
0

Hi Aniruddha!
Thanks for reaching out.

Only the RENAME statement is used with the ALTER TABLE statement. The other can be used without it.

Hope this helps.
Best,
Tsvetelin

Helpful answer

Submit an answer

related questions

Islam Elkhateeb
3
26
Resolved: can't add row, I do may trail and it all back with errors
Alessandro Imbrìaco
2
26
Resolved: Explanations to questions 15 and 29
Marcus Wern Han Leong
2
16
Why did you not do not null, primary key and auto increment for customer id in the solution?
Michele Cannito Buch
0
14
Resolved: DROP FOREIGN KEY sales_ibfk_1 -- huh?
Snoor Salihi
0
10
Resolved: Drop table from the database
Nourhan Osama Ahmad
0
8
how to upload the assignment and remark on it 
Maxime Darbouze
0
8
I wrote the same command that is the sql file and it did not work
Maxime Darbouze
0
8
1681 Integer display width is deprecated and will be removed in a future release.