CREATE TABLE foo SELECT * FROM bar

copies the table foo and duplicates it as a new table called bar.

How can I copy the schema of foo to a new table called bar without copying over the data as well?

4 Answers
4

Tags:

Leave a Reply

Your email address will not be published. Required fields are marked *