cancel
Showing results for 
Search instead for 
Did you mean: 

how to add new column in the sybase IQ to the existing table(Column i am trying to add has to be in the first column in the table)

Former Member
0 Kudos

Hi All,

how to add new column in the sybase iq to the existing table(Column i am trying to add has to be in the first column in the table)

Please advice!!

Thanks,

Aparna

Accepted Solutions (1)

Accepted Solutions (1)

saroj_bagai
Contributor
0 Kudos

YOu cann't control column ID  of column , but you can use alter table  to add new column to existing table

alter table add newcol char(10)

Answers (1)

Answers (1)

0 Kudos

IQ data is stored column wise, so what difference it makes where the column in the schema of table? For any load/insert/select etc query, you can define the column order as you like in that particular SQL.