Pari13 -1 Junior Poster in Training

Hey Brother,
I have need to create new table into new database from exist table of old database.
So how I can copy that much table into other database.
I have tried below code. but it give error at "IN".

SELECT *
INTO dbo.pqrnew IN "NewDatabase"
FROM dbo.pqr

I hope U got idea..If U got idea or understand than reply ..
thanks in advanced......

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.