In this lesson we are going to study about how to drop a table.
DROP TABLE Table_name;
In this syntex drop table is the keyword and the table name specify the name of table to be droped.
Example: Drop the temp_employees table
drop table temp_employees.
Related article:
I am interested in hearing your feedback, so that I can improve my articles and learning resources for you.connect with us on facebook, twitter
- Drop table removes the table and all its data from the database entirely.
- Drop table is different from deleting all records from the table .
- Deleting all of the records in the table leaves the table including column and constraint information .
- Dropping the table removes the table definition as well as all of its rows.
DROP TABLE Table_name;
In this syntex drop table is the keyword and the table name specify the name of table to be droped.
Example: Drop the temp_employees table
drop table temp_employees.
Related article:
I am interested in hearing your feedback, so that I can improve my articles and learning resources for you.connect with us on facebook, twitter
What's up to every one, as I am in fact eager of reading this webpage's
ReplyDeletepost to be updated on a regular basis. It contains pleasant information.
Check out my page - bad credit loans you can make payments
My web blog 7000 dollar loans no credit check
good one
ReplyDeleteIt's awesome in support of me to have a website, which is helpful in favor of my knowledge. thanks admin
ReplyDeleteFeel free to surf to my blog: relevant web page
There will be fewer sites on the server and the quality of support will be higher for only a
ReplyDeletefew dollars more per month. Don’t jump into the first finding, because if you research little more you can find better set of
resources for the same price. It is very important to
notice that the company which gives the reseller package will
only maintain the server and will run that server also.
my web site - lanka web hosting