Tuesday, November 27, 2018

Altering column size in SQL Server

How to change the column size of the DocumentName column in the tbldocuments table from nvarchar(100) to nvarchar(500)

ALTER TABLE [tbldocuments]
ALTER COLUMN [DocumentName] nvarchar(500) NOT NULL

Syntax:-
 ALTER TABLE [table_name] ALTER COLUMN [column_name] varchar(500) NOT NULL

No comments:

Post a Comment