StumbleUpon  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 Nulgath Secret Walkthrough