Alter Table using Enterprise Manager in SQL Server

In this article I am going to explain how to alter a table using Enterprise Manager in SQL Server.
  • 2707

Introduction

In this article I am going to explain how to alter a table using Enterprise Manager in SQL Server. Alter TABLE statement is used to Alter table in SQL server. In SQL server we can alter table using Enterprise Manager. 

Steps to Alter table using Enterprise Manager in SQL server

Step 1 : Start SQL server :

Clipboard01.jpg

Step 2 : Expend database and select database => Right click on Table => Then click Design :

Clipboard03.jpg

Step 3 :  A new window appear in right side, here we see that it has three column :

Clipboard05.jpg

Step 4 : Now click on last row, enter name and data type of column. Here we add new column :

Clipboard07.jpg

Step 5 : Now right click window  and select save table :

Clipboard09.jpg


© 2020 DotNetHeaven. All rights reserved.