on 04-23-2013 4:36 PM
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
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)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.