ASPForums.Net RSS Feed additions to the content that appears on ASPForums.Net(c) 2019 All rights reserved.alter column<p>try one by one like ,</p> <p>alter column Name nvarchar(30) null<br />alter table<br />alter column T_name nvarchar(20) null<br />alter table<br />alter column C_name nvarchar(30) null</p>, 12 Apr 2012 05:47:19 GMTalter column<p>thanks i did it and it worked</p> <p>i have many table that i should change them is there any shorter way?</p> <p>&nbsp;</p>, 12 Apr 2012 08:28:45 GMTalter column<p>no their is no any short cut u have to write all this query and execute</p>, 12 Apr 2012 08:52:14 GMTalter column<p>ok&nbsp;</p> <p>thanks alot</p>, 12 Apr 2012 08:58:46 GMT