create a new table based on an existing view

 The absolute fastest and cleanest way to create a new table with the exact same schema (structure and data types) as an existing view in SQL Server is to use a SELECT ... INTO statement combined with a WHERE 1 = 0 clause.

The WHERE 1 = 0 condition acts as a false flag—it forces SQL Server to clone the structural definition of the view without actually copying any of the rows into your new table.

Run this script in your SQL Server Management Studio (SSMS):

SQL

-- Creates an empty table with the exact structure of the view

SELECT *

INTO q2AIR_MDPL_RPT_TimecardSalaryReport

FROM q2vAIR_MDPL_TimecardSalaryReport

WHERE 1 = 0;

Cheers

Samitha