SQL Tutorial - 11: Removing Tables from Database Video Lecture | Microsoft SQL for Beginners - Database Management

hello guys welcome to my channel this is
the 11th tutorial in this course and in
this tutorial we are going to understand
how we can delete or drop tables in SQL
right so this the command that you have
to use to drop tables or to remove them
from your database is the drop table
command and as the buret in the
presentation reads the drop table
command is used to remove a table and
all its contents permanently from
database and you know you have to be
careful while using this command because
if you execute it once then the table
gets removed and this is providing
you're not using the begin and cron you
know transaction control statements and
you know we're going to talk about those
later on but you know you just have to
be careful while using drop table you
know don't just play with it and the
syntax the drop table statement is
really very simple you just have the
keywords drop and table and then you put
in the name of the table that you want
to remove from your database and put in
a semicolon and you execute the
statement and it would get executed and
there are a couple of ways of confirming
whether the table that you wanted to
remove has been removed or not so you
know you you can either execute the show
tables command or you can describe your
table and if the table exists then you
know you would get the definition of it
in the result set
but if it does not exist in you would
get an error message right so now let's
see how to remove tables in the MySQL
workbench so as you can see in my test
database I've got two tables the EMP
underscore info table and the employee
table and what I'm going to do is I'm
going to try to remove the EMP
underscore info table using the drop
table command so I will type and drop
and then the keyword table and then I'll
type in the name of the table that I
want to remove which is EMP underscore
info I will put in a semicolon at the
end and press T ctrl enter key
combination and you would see that in
the output section I get the message
drop table EMP underscore info and you
see this green you know nice check mark
which means the proper the command has
been processed successfully and now if I
would the you know click on the refresh
button in the object browser section I
would
see that the EMP underscore info you
know table gets removed from the you
know items that were displayed and the
other way of confirming whether the
command the drop table was executed
successfully or not is obviously to
execute the de SC command and EMP
underscore info and put in the semicolon
and press the control enter key
combination you would see that in the
output section I do not get this green
checkmark this time I get the red cross
symbol and I also get an error message
that the table EMP underscore info
doesn't exist right so that means that
the table was successfully dropped so
anyway that's all I wanted to discuss
with you in this tutorial and thank you
so much for watching and please
subscribe to my channel case you're
already in the next tutorial we are
going to discuss something interesting
for sure and see you soon