Joined: 17 Oct 2004 Posts: 190 Location: hyderabad
I need to add 3 columns to a table
(The properties of 3 fields are data type Char(15) and NOT NULL with default) and these are non-primary key fields.
Can we add 3 columns to a table using single alter statement. If yes, please give an example.
Joined: 18 Jul 2007 Posts: 2150 Location: At my coffee table
[quote="Craq Giegerich]You can only add 1 column with each alter table. Three columns would require three alters.[/quote]That is what the error says, but that does not agree with the syntax provided by link above.....