Skip to content

DW BI MASTER

Just another WordPress site

Menu
  • Home
  • Sample Page
Menu

SQL – Drop Table

Posted on October 29, 2017
SQL – Drop Table is DDL (Data definition language) statement.The Drop Table command is used to delete table from database.

Drop Table Statement :

  • Removes named table and all rows within it.
  • Removes data indexes, triggers, constraints for named table.

Syntax For Drop Table :

Basic syntax for Drop table is as follows :

DROP TABLE Table_name

Please note that once the table is deleted all the information available in table will be deleted forever. So always be careful before using drop statement.

READ HERE : SQL – ALTER TABLE

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Search

Recent Posts

  • What is Machine Learning ?
  • What is Data Lake ?
  • What is Change Data Capture ?
  • Introduction to Data Mining
  • How to Create Free Tier AWS Account

Archives

  • July 2021
  • May 2018
  • January 2018
  • November 2017
  • October 2017
©2022 DW BI MASTER | Design: Newspaperly WordPress Theme