|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.
But that scripts only copy the structure of the tables, they didn't copy other things, such as triggers, etc.