Help me coping table from one Database to another

shailu · May 19th, 2005, 01:56 AM

I am trying to copy table structure from one db to another here is what I wrote in my SQL Query

SELECT * INTO UserMaster IN 'Sunetra' FROM EPMAgent WHERE 0 = 1
but it gives me an error "Incorrect syntax near the keyword 'IN'"

Help me :)

DMK · May 19th, 2005, 06:23 AM

Hi ,
I am assuming 'Sunetra' is the database name and UserMaster is the tablename.
Instead of using "UserMaster IN 'Sunetra'" Use -> Sunetra.dbo.UserMaster.