Databse New Table

Question

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.

Jitendra Kumar · Answer

Use this :- CREATE TABLE new_table AS (SELECT * FROM old_table WHERE 1=2);

Pankaj Kumar Choudhary · Answer

Hello @Avinash you can use this method SELECT * INTO New_Table FROM Old_Table WHERE 1 = 2