ASPForums.Net RSS Feedhttp://www.aspforums.net/Handlers/RSS.ashxLatest additions to the content that appears on ASPForums.Net(c) 2019 www.aspforums.com. All rights reserved.alter column<p>try one by one like ,</p> <p>alter column Name nvarchar(30) null<br />alter table dbo.clothing<br />alter column T_name nvarchar(20) null<br />alter table dbo.clothing<br />alter column C_name nvarchar(30) null</p>https://www.aspforums.net:443/Threads/187224/alter-column/https://www.aspforums.net:443/Threads/187224/alter-column/Thu, 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>https://www.aspforums.net:443/Threads/187224/alter-column/https://www.aspforums.net:443/Threads/187224/alter-column/Thu, 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>https://www.aspforums.net:443/Threads/187224/alter-column/https://www.aspforums.net:443/Threads/187224/alter-column/Thu, 12 Apr 2012 08:52:14 GMTalter column<p>ok&nbsp;</p> <p>thanks alot</p>https://www.aspforums.net:443/Threads/187224/alter-column/https://www.aspforums.net:443/Threads/187224/alter-column/Thu, 12 Apr 2012 08:58:46 GMT