Loading

Databse New Table

Avinash Vajpayee

we want to create a new table with the help another table which have 20 records in it .
How with help of query or sql syntax we create another table which same no. of records but not data in it.

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Pankaj Kumar Choudhary11y ago
Hello @Avinash you can use this method

SELECT
* INTO New_Table

FROM Old_Table
WHERE 1 = 2
0

Jitendra Kumar11y ago

Use this :-

CREATE TABLE new_table   AS (SELECT *  FROM old_table WHERE 1=2);

+1