Query

Question

hi Dudes I have create some table by mistakely these tables are in Master Database so i want to trasfer them in my Database how i can i trasfer them by command  is it possible can any one tell me....?

Manish Dwivedi · Answer

Hi By this way you can copy tables from one database to another SELECT * INTO AdventureWorks.dbo.CustomersTemp FROM Northwind.dbo.Customers

Manish Dwivedi · Answer

Hi Take the reference of my blog to get all Tables Click Here

Smart Lucky · Answer

It means table structure will be copy.and how can i see the all tables in database as in oracle catalog but not confirm but how in sql server 2005..?

Vilas Gite · Answer

Hi Smart As per Suthish Sir said its only copy tables but constraints such as PK will not set properly. ----------------------------------------------

Suthish Nair · Answer

This will just move the data from one DB to another not PK FK Indexes etc... Another way is to use Management Studio.