Quick way to copy a table structure

Here’s a very quick way to copy a table structure if you don’t want to script the table using the Management studio GUI:

SELECT TOP 0 * INTO #DimProduct_Copy FROM DimProduct

Leave a Reply