Modify the column width by using T_SQL 2

[wg26]

Hi Everyone:

Can anyone please tell me how I can modify the column (varchar) width from 255 to say 2000 by using T_SQL....what is the syntax? I know I can get it done through EM.But I need to know how to do it by using T_SQL...Thanks

 

[tlbroadbent]

Alter Table tablename
Alter column colname varchar(2000)

This is explained in SQL BOL under the topic "Alter Table." Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/prog.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.

 

[ccuster]

How about if you wanted to use a variable, say find the max len of a column then use the variable for the new size of a column, when I try this I get incorrect syntax.

alter table temp
alter column abc char(@newSize)

 

[tlbroadbent]

You'll have to use dynamic SQL to accomplish this.

Declare @sql varchar(200)

Select @sql='alter table temp' +
' alter column abc char(' +
str(@newSize) + ')'

exec(@sql)
Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/prog.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.