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
