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
ALTER TABLE [tbldocuments]
ALTER COLUMN [DocumentName] nvarchar(500) NOT NULL
Syntax:-
ALTER TABLE [table_name] ALTER COLUMN [column_name] varchar(500) NOT NULL