SQL query to create a clone of existing table without using Create Command.

Hi Amatya,

what is use of "Top 8" here in above query?

I think it will return top 8 records of table. But you are creating clone of the table. And, clone should have all records of source table.

Sure Aruntuteja "I think it will return top 8 records of table." and the clone will be created(structure).
Data will not be same here. If you want same data we have copy functionality.
if any doubt, please ask .

Thanks & Regards,
Amatya

Hi Amatya,

Your query is creating new table "tblDNFRec_Temp". And that new table have 8 records of old table "tblDNFRec". This is happening because select query is returning top 8 records.

If you want to create new table only, then your select query should return 0 records. And, that you can achieve this by just putting where clause in select query like "where 1 = 2". This where clause will always return false and hence no record will be returned. Thus only clone table will be created without any records.

Thanks...

Yea Aruntuteja.. Now you got it.

Thanks
Amatya

Hi,

So, please change and update the query used in this post so that other new readers get the correct query for achieving the mentioned clone table only (without any record).