How to Alter and Drop a Table in SQL
In this article I am going to explain about how to alter and drop a table in SQL.
Introduction
In this article I am going to explain about how to alter and drop a table in SQL. ALTER TABLE statement is used to modify any table. Using this statement you can insert new column, delete column from any table. This statement is also part of DML (Data Manipulation Language).
Example
Fallowing Statement create a vipendra table in DATABASE

Fallowing Statement alter vipendra table and add a new column

Fallowing Statement fetch data from vipendra table

Fallowing Statement alter vipendra table and delete a column

Fallowing Statement fetch data from vipendra table

Fallowing Statement delete table vipendra
