How to drop column from temporary table ;;
i tried by this query ,but error message gives "Incorrect syntax near '@Temp"
my query is
alter table @Temp drop column id
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Pravin MorePosted Nov 24, 2011, 2:49 AM
try this query
alter table #Temp drop column id
i think you misstyped @ intead of #.
Thanks,
Pravin.