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.56
I 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 ago

back soft...
ما را در سایت back soft دنبال می کنید

برچسب : duplicating a table in sql,duplicating a table in sql server,duplicating a table in mysql,duplicating a table in oracle,duplicating a table in sql server 2008,duplicating a table in word,duplicating a table in access,duplicating a pivot table,duplicating tables in excel,duplicating table, نویسنده : استخدام کار backsoft بازدید : 471 تاريخ : پنجشنبه 13 آبان 1395 ساعت: 14:21