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.
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 :
Step 2 : Expend database and select database => Right click on Table => Then click Design :
Step 3 : A new window appear in right side, here we see that it has three column :
Step 4 : Now click on last row, enter name and data type of column. Here we add new column :
Step 5 : Now right click window and select save table :