InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 19 Jun 2013 06:34:55 GMT20http://www.sqlservercentral.com/Forums/Topic1040888-392-1.aspxI don't believe there is a way to do that. You can add multiple columns in a single command, but not alter multiple columns all at once.Copy-and-paste can remove most of the work with that. Might be even simpler if you're modifying a predictable set of columns, and you query sys.columns to build the basic strings.[code="sql"]select 'alter table [' + object_name(object_id) + '] alter column [' + name + ']' from sys.columnswhere object_id = ...;[/code]Something like that.Thu, 30 Dec 2010 08:33:09 GMTGSquaredhttp://www.sqlservercentral.com/Forums/Topic1040888-392-1.aspxI need to alter definition of two columns in a table and its being done like this :ALTER TABLE dbo.JURISDICTION_FIELDALTER COLUMN FIELD_CODE NVARCHAR(60) NOT NULL;ALTER TABLE dbo.JURISDICTION_FIELDALTER COLUMN [DESCRIPTION] NVARCHAR(2000) NULL;If I need to update 20 columns in a table, there will need to be 20 ALTER TABLE statements. Is there a way to update all 20 columns using a single ALTER TABLE statement?Please let me know if you need more clarifications.Thank You.Thu, 30 Dec 2010 08:28:45 GMTakhandelshttp://www.sqlservercentral.com/Forums/Topic1040888-392-1.aspxI don't think you can do it in SQL 2008 R2 either. Not sure about Denali.Thu, 30 Dec 2010 08:21:17 GMTGSquaredhttp://www.sqlservercentral.com/Forums/Topic1040888-392-1.aspxCan you elaborate in better can you have some examples for it like how with scenariosThanksParthiThu, 30 Dec 2010 07:59:11 GMTparthi-1705http://www.sqlservercentral.com/Forums/Topic1040888-392-1.aspxHi All,Does anybody know if there is a way to update column definition of multiple columns in a single ALTER statement in SQL Server 2008 or Denali CTP 1 ?I am aware it is not possible in SQL Server 2005.Thank YouThu, 30 Dec 2010 07:23:19 GMTakhandels