Alter table in MsSsql
Adding a column into Existing Table(Contact)
ALTER TABLE Contact ADD Phone nvarchar(50) NULL
Removing a Column from a existing Table
ALTER TABLE Contact DROP COLUMN Phone
Altering Data Type of a column
(phone has the value nvarchar(50) now we like to change it to the varchar(20))
ALTER TABLE Contact ALTER COLUMN Phone varchar(20)
ALTER TABLE Contact ADD Phone nvarchar(50) NULL
Removing a Column from a existing Table
ALTER TABLE Contact DROP COLUMN Phone
Altering Data Type of a column
(phone has the value nvarchar(50) now we like to change it to the varchar(20))
ALTER TABLE Contact ALTER COLUMN Phone varchar(20)
Comments
Post a Comment