Changing id to empid in warehouse
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
0
4 comments
Pradeep Jha
1
Changing id to empid in warehouse
Learn Microsoft Fabric
skool.com/microsoft-fabric
Helping passionate analysts, data engineers, data scientists (& more) to advance their careers on the Microsoft Fabric platform.
Leaderboard (30-day)
powered by