May 29, 2002 #1 apollo11 Programmer Apr 5, 2001 35 US Can I change the size of an already existing not null nvarchar column in SQL Server 7.0 SP2? without dropping and recreating the table?
Can I change the size of an already existing not null nvarchar column in SQL Server 7.0 SP2? without dropping and recreating the table?
May 29, 2002 #2 crystalized Programmer Jul 10, 2000 390 CA Alter Table TABLENAME Alter column COLUMNNAME varchar(SIZE) I have used this syntax successfully for exactly that purpose, just change the all caps values to the values you need. Crystal crystalized_s@yahoo.com -------------------------------------------------- Experience is one thing you can't get for nothing. -Oscar Wilde Upvote 0 Downvote
Alter Table TABLENAME Alter column COLUMNNAME varchar(SIZE) I have used this syntax successfully for exactly that purpose, just change the all caps values to the values you need. Crystal crystalized_s@yahoo.com -------------------------------------------------- Experience is one thing you can't get for nothing. -Oscar Wilde