Alter table alter column 
Author Message
 Alter table alter column

In an alter table/alter column statement is it possible to use one
statement for multiple columns or do you have to use several statements
each refrencing an individual column
Bill

*** Sent via Developersdex http://www.***.com/ ***
Don't just participate in USENET...get rewarded for it!



Mon, 13 Mar 2006 21:38:26 GMT
 Alter table alter column

Unfortunately you can only alter one column per ALTER TABLE statement.

But you can add multiple columns in one statement:
ALTER TABLE Sometable ADD col_X INTEGER, col_Y INTEGER

--
David Portas
------------
Please reply only to the newsgroup
--



Mon, 13 Mar 2006 22:11:31 GMT
 Alter table alter column
no. you have to do one alter table per column.

--
-oj
RAC v2.2 & QALite!
http://www.rac4sql.net


Quote:

> In an alter table/alter column statement is it possible to use one
> statement for multiple columns or do you have to use several statements
> each refrencing an individual column
> Bill

> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!



Mon, 13 Mar 2006 22:07:48 GMT
 
 [ 3 post ] 

 Relevant Pages 

1. Help with Alter Table Alter Column

2. Alter Table Alter Column Syntax

3. alter table alter column

4. Alter table alter column syntax

5. Alter table Alter column problem.

6. ALTER TABLE ALTER COLUMN

7. ALTER TABLE ALTER COLUMN to set Default

8. Alter table alter column text

9. syntax for ALTER TABLE ALTER COLUMN DEFAULT

10. Errors With ALTER TABLE/ALTER COLUMN

11. Alter table alter column

12. ALTER TABLE ALTER COLUMN


 
Powered by phpBB® Forum Software