SQL Tutorial - 53: The TRUNCATE TABLE Command Video Lecture | Microsoft SQL for Beginners - Database Management

hello wise women my channel this is the
53rd detail in this course and in this
tutorial we're going to talk about the
truncate table command and the trunk a
command is used to empty a table of all
the content that's a few blog bunch of
records in a table if you want to remove
all the records in one go then you can
use a truncated of the morning you know
the new command also serves the purpose
but then there are some significant
differences between the need and crumb
cake now before we talk about the
differences between the two commands
another thing that we know about
truncate is that when you use a
computable combine the structure of the
table remains intact
right so it will only remove the content
but it's not going to mess up with the
structure of the table so the fields
that we have in the table we're going to
be as is they so now let's talk about
the differences between from commute so
firstly come clear is a baby well
command and the bleed is a BML command
and what that means is that when you
perform the lead operation on a table
you can load it back right so if you
needed data there accidentally now
suppose and if you want to recover it
then it's possible with the delete
command but if you use truncate on a
table then you know once you execute it
you cannot get your data back and
another difference is that when you use
the delete command you know the space
that was occupied by the data in the
table in a memory that space is not
freed so you know if you want to feed
that space if you want to make that
space available for something else then
you have to use the truncate command and
again you know this might not be
something very significant for smaller
tables you know with like let's say 15
rows or 20 goals but then if you've got
tables about thousands and thousands of
words and if you want to you know free
the data space that you know the data in
the table is occupying then in that case
it would make sense for you to you know
decide properly which command you want
to use very want to use truncate already
already usually right so now let's check
out the syntax of the truncate table
command is the supplier on a table so
it's very simple you just type in
truncate right and then table and then
followed up with the name of the table
so
let's say I want to remove all the data
that I have in the tutorial table so I
just open tutorial and the i-witness
semicolon at the end and when I execute
this I won't get any result set and
that's because you know I'm not supposed
to get one but I can check out whether
the rows that I had a burrito table
whether the data has been deleted or not
so to check that I can run a select star
from tutorial query so there you go when
I execute this query I see that there is
no data in the table left so that's it
about crumb cake table in the next
tutorial we're going to check out
something interesting again about SQL
maybe we'll talk a little about sub
queries so thanks for watching this one
and you may subscribe to my channel if
you haven't already and I'll see you
soon