sheetu sachdeva

sheetu sachdeva

  • NA
  • 33
  • 14.5k

Check availability of a table

Feb 20 2007 4:38 AM
i m creating a table using this query Select * into newtable from oldtable This is query wen u want to create an empty newtable with a structure of old table now , uptill this it works fine , but now i want to check if newtable already exists so i wrote if not exists ( Select * into newtable from oldtable) it gives syntax error why?

Answers (6)