Hi guys, Welcome to the Advanced Video Search Engine, and you are watching TRUNCATE TABLE & DROP TABLE Commands in SQL || Lesson 43 || DBMS || Learning Monkey ||. That video is uploaded by Learning Monkey at 2021-10-25T20:46:57-07:00. We are promoting this video only for entertainment and educational purpose only. So, I hope you like & enjoy it. [fXnWVvOZbRc]
| Name | TRUNCATE TABLE & DROP TABLE Commands in SQL || Lesson 43 || DBMS || Learning Monkey || |
| Video Uploader | Video From Learning Monkey |
| Upload Date | This Video Uploaded At 26-10-2021 03:46:57 |
| Video Discription | TRUNCATE TABLE and DROP TABLE Commands in SQL In this class, we will understand TRUNCATE TABLE and DROP TABLE Commands in SQL. We have already discussed the concepts of alter table. TRUNCATE TABLE and DROP TABLE Commands in SQL To understand, we will use the user’s table as shown below. In the above table, we have two rows. TRUNCATE TABLE Command The TRUNCATE TABLE statement deletes the data inside a table, but not the table itself. If we want to delete all the rows in the table, we have to use the truncate command. With the truncate, we can delete all the rows in the table, but not the table itself. The syntax for truncate is as shown below. TRUNCATE TABLE table_name; Now, we will truncate the user’s table. TRUNCATE TABLE users; We will check whether the rows have been deleted or not by using the select command. The table has been truncated. DROP TABLE Command The DROP TABLE statement is used to drop an existing table in a database. To delete the structure of the table, we use the drop command. The syntax to drop a table is as shown below. DROP TABLE table_name; DROP TABLE users; The user’s table no more exists. Let us check with the select command. #learningmonkey #dbms #placements #gatecse #gatedbms #campusplacements Link for playlists: https://www.youtube.com/channel/UCl8x4Pn9Mnh_C1fue-Yndig/playlists Link for our website: https://learningmonkey.in Follow us on Facebook @ https://www.facebook.com/learningmonkey Follow us on Instagram @ https://www.instagram.com/learningmonkey1/ Follow us on Twitter @ https://twitter.com/_learningmonkey Mail us @ learningmonkey01@gmail.com fXnWVvOZbRc |
| Category | Education |
| Tags | TRUNCATE TABLE & DROP TABLE Commands in SQL | truncate table in dbms | drop table in dbms | drop table in sql | sql | sql interview questions and answers | sql queries interview questions and answers | dbms | database management systems | learning monkey | learning monkey dbms | dbms for placements | dbms for placement preparation | gate cse | gate cse dbms | gate cse free lectures | gate cse free online coaching | gate cse free course | gate cse preparation | gate cse syllabus |
