ALTER table - only add one column at a time? - Level Extreme

Level Extreme platform

Subscription

Corporate profile

Products & Services

Support

Legal

Français

ALTER table - only add one column at a time?

Message

From

15/07/2008 19:28:00

Kurt Huebner
Blue Diamond Growers
Sacramento, California, United States

To

15/07/2008 19:16:47

Naomi Nosonovsky
Wisconsin, United States

General information

Forum:

Microsoft SQL Server

Category:

SQL syntax

Title:

Re: ALTER table - only add one column at a time?

Environment versions

SQL Server:

SQL Server 2005

Miscellaneous

Thread ID:

01331519

Message ID:

01331527

Views:

8

This message has been marked as a message which has helped to the initial question of the thread.

Naomi,

You are correct, you can ADD multiple columns in a single statement, but you can only ALTER one column at a time in a SQL statement.

Kurt
>Kurt,
>
>Can you alter two columns at once? There is no sample in BOL and I assume it's impossible.
>
>I need
>ALTER TABLE Friends ALTER COLUMN [EmergencyContactPhone1] [varchar](25) NULL,
> [EmergencyContactPhone] [varchar](25) NULL
>
>
>(change type of both columns).

Click here to load this message in the networking platform