Avatar of Murray Brown
Murray Brown
Flag for United Kingdom of Great Britain and Northern Ireland

asked on 

VB.net Duplicating a table - primary key not created


In my VB.net app, I use the following SQL statement to duplicate a table. If  the original table has an Identity field that is a primary key the new table created has this identity column but it is no longer a primary key field. Why would thid be?

sSQL = "SELECT * INTO [My New Table] FROM [My Old Table]"
Visual Basic.NETMicrosoft SQL Server

Avatar of undefined
Last Comment
Murray Brown

8/22/2022 - Mon