Hi guys ,
I need your help!
I'm getting error in new sql query when i created a table and tried to execute in warehouse
for example
CREATE TABLE EMP(ID INT , ENAME VARCHAR(40)); <---- table is created
-- change ID to EMPID
ALTER TABLE EMP CHANGE COLUMN ID EMPID INT; <----- getting syntax error
kindly let me know alternate ways to just change ID in warehouse ,Thank you