Matt Miller (3/12/2008)
Look at using Select ... INTOExample:
Select *
INTO MyNewTable
from MyOldTable
Uses whatever it derives from the query to make a table.
And if you want to "Create As" like this but without any data:
Select *
INTO MyNewTable
from MyOldTable
Where 0=1
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]