Alter nvarchar Size for a Column

TABLE is the table of your database, and COLUMNis a column on the table.

ALTER TABLE Customer ALTER COLUMN Address nvarchar(100);