0

I have a table like below format.

CREATE TABLE Customer (
  number VARCHAR(40)  NOT NULL, --col 1 
  name   VARCHAR(100) NOT NULL, --col 2
  ssn    VARCHAR(50)  NOT NULL, --col 3
  age    INTEGER      NOT NULL, --col 4
)

I want to add a new column in the table. If I using the below command I got the ‘NewColumn’ as ‘col 5’.

ALTER TABLE Customer ADD NewColumn INTEGER

How to add the ‘NewColumn’ as ‘column 3’ ?

Any help appreciated,

Thanks,
Mani Muthu

2
Contributors
1
Reply
2
Views
7 Years
Discussion Span
Last Post by pritaeas
This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.