clone a sql table and all its content? including input data?

[jarmanje]

Hello, i've been looking around for a way to clone a sql table and all of its content

is there an sql to do this?

i cannot find it..

[Cota]

I would try something like this

CREATE TABLE newTableName SELECT * FROM oldTable WHERE 1=1



That will copy the structure and all the data into the new table.