How to Alter and Drop a Table in SQL

Posted in SQL | Table Design June 26, 2019
Tags: Alter Table in SQL, Drop a Table in SQL, alter clause, add clause, drop clause
In this article I am going to explain about how to alter and drop a table in SQL.
  • 2601

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

Clipboard02.jpg

Fallowing Statement alter vipendra table and add a new column

Clipboard04.jpg

Fallowing Statement fetch data from vipendra table

Clipboard06.jpg

Fallowing Statement alter vipendra table and delete a column

Clipboard08.jpg

Fallowing Statement fetch data from vipendra table

Clipboard10.jpg

Fallowing Statement delete table vipendra

Clipboard12.jpg

    © 2020 DotNetHeaven. All rights reserved.