msmeth
10-26-2004, 05:30 AM
How can I create a table using the fields from a large join as the fields in one large master table? I don't want the data in the new table; just a new blank table with the fields the same....I want it to be as generic as possible so that if any of the souce tables are changed (a new column added), the query will add this column to the master table too. I could create a view (this is SQL Server 2000) into a new table and delete the contents I suppose.....is there another way?