Cyber Cafeteria

Add new columns to existing table. Using by Alter Table.

admin

Aug 31, 2012

Add new columns to existing table

ALTER TABLE [YOURDATABASENAME].[dbo].[YOURTABLE] ADD NEWCol1 NVARCHAR(20);

ALTER TABLE [YOURDATABASENAME].[dbo].[YOURTABLE] ADD NEWCol2 DATETIME;

ALTER TABLE [YOURDATABASENAME].[dbo].[YOURTABLE] ADD NEWCol3 NVARCHAR(20);

ALTER TABLE [YOURDATABASENAME].[dbo].[YOURTABLE] ADD NEWCol4 DATETIME;

admin