Creare Unique/Primary Key when using SELECT* INTO
Posted on 2014-10-21
I have not been able to find a definitive solution ...
I am using Access 2010 to Pass a Make Table Query to SQL 2012 Express, which creates a new table based on a value in some column data and my query does work; however I always get an Access prompt to select a Primary/Unique Key.
Is there anyway to specify this Primary/Unique Key in the SELECT * INTO statement?
Here is my query ...
/****** Object: Table [SQL_DB_Name].[dbo].[Raw_Data] Script Date: 10/21/2014 12:53:41 PM ******/
SELECT * INTO [ALL_Zero_ID_Rows] FROM [Raw_Data]
WHERE CAST([The_Number_in_This_Column] AS INTEGER) = 0;