on 06-27-2012 7:47 AM
Hello,
I am looking for the SQL command to change an existing column data type from BIGINT to INTEGER.
Thanks,
Ronen
Hi Ronen,
Try ALTER TABLE SCHEMA.TABLE ALTER (<COLUMN> <COLUMN_TYPE>);
Thanks,
Anooj
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Anooj,
I need to change the datatype from integer to nvarchar so i used the above script which you gave.
ALTER TABLE "R_TEST"."PRO_TRACKING_2" ALTER ("Style" NVARCHAR(10));
But its showing following error
"invalid datatype: cannot allow NVARCHAR type column: Style: line 1 col 46 (at pos 45)"
I tried with VARCHAR Instead of NVARCHAR but still same error.. could you tell me what is the issue with this..
regards,
Mathivanan
User | Count |
---|---|
86 | |
10 | |
10 | |
9 | |
6 | |
6 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.