مطالب مرتبط با «duplicating a table in sql server 2008» در back soft | نویسنده: استخدام کار
Duplicating a table in dashDB
Vote count: 0 I want to create a duplicate table in dashDB (with or without the original data, it does not really matter, the table structure is what is important). I tried:SELECT * INTO new_table FROM old_table;but I get this error:"new_table" is not valid in the context where it is used.. SQLCODE=-206, SQLSTATE=42703, DRIVER=3.69.56I also tried:CREATE TABLE new_table AS (SELECT * FROM old_table);but i get this error:An unexpected token "END-OF-STATEMENT" was found following "AS (SELECT * FROM old_table". Expected tokens may include: "WITH DATA, WITH NO DATA".. SQLCODE=-104, SQLSTATE=42601, DRIVER=3.69.56 asked 29 secs agoMike Pala Let's block ads! بخوانید...
ادامه مطلب
