StumbleUpon  Del.icio.us  Facebook  Reddit  Add to diigo  


Follow - Monx007
Article Time Stamp: 27 June 2009, 20:47:42 GMT+7

Microsoft SQL (MS SQL): Sample SQL Script to Create A Table Structure Based On Another Table



In this example, we want to create a table structure named by tbl_target, based on the structure of an existing table named by tbl_source, without copying the data. We use Transact-SQL script for this example.


SELECT TOP 0 * INTO tbl_target FROM tbl_source;



But that scripts only copy the structure of the tables, they didn't copy other things, such as triggers, etc.

Article Source: Monx Digital Library

Copyrighted@ Monx Digital Library, otherwise stated
Use of our service is protected by our Terms of Use



 Back To Previous Page ...  



 

 

 

AQWorlds Banner