In this blog I have described how to add new column in existing table. For demonstration I have used a table that given below.
CREATE TABLE [dbo].[EmpInfo]
(
[ID] INT IDENTITY PRIMARY KEY,
[Name] VARCHAR(50),
[Date] VARCHAR(50)
)
Syntax :
ALTER TABLE <Table Name> ADD <New Column Name> <Data Type> <Size>
Example:
ALTER TABLE [dbo].[EmpInfo]
ADD [Address] VARCHAR(200)
Leave Comment