Total Pageviews


SQL Server : Copy table from one database to another database

Come across situation where I need to copy table from database “db2 “to database “db1”  with data, for that a very handy & useful query given below :-


             SELECT * INTO db1.dbo.table1
             FROM db2.dbo.table2

Please mind that this query only copies table schema and data only.

All constraints, indexes, statatics, you need to use alternatives


questions to ask said...

Personally, I'm very comfortable that this request copies the bottom of the table and the table itself and no extra information.

Anaminka said...

With our Russian Escorts in Jaipur and escorts services, you may really improve stage of fun by its quality services different. Sure! This assists its people to victory over all the gloom and depressive disorders from your lifestyle and appeases your delicate wishes specifically.So, you may do a trip at web page and can get your wish suggested with an outstanding woman escort. Check our other services also...
Russian Escorts in Jaipur
Russian Escorts in Jaipur
Russian Escorts in Jaipur
Russian Escorts in Jaipur
Russian Escorts in Jaipur

Post a Comment

Twitter Delicious Facebook Digg Stumbleupon Favorites More

Design by Free WordPress Themes | Bloggerized by Lasantha - Premium Blogger Themes | Affiliate Network Reviews