How to create a table similar to another table without copying the data at creation?

Question

I have a table books, I want to create table Book101 and then copy the contents of table books into it.

I am puzzled by the differing requirement in the title and question - to copy or not to copy? — P.Salmon, Jan 09 '21 at 08:13

score 0 · Accepted Answer · edited Jan 09 '21 at 06:10

0

CREATE TABLE Book101 AS SELECT * FROM books WHERE 1=0;

Above example will create only structure.

If you want to Clone the table with structure and data both then you can you below one:

CREATE TABLE Book101 AS SELECT * FROM books;

edited Jan 09 '21 at 06:10

Owen Kelvin

answered Jan 09 '21 at 05:48

anand.malvi

1 Answers1