I'm having an issue restoring a database table with a primary key constraint. Is it possible to restore a table without the PK? or nonclustered?
I can restore other tables fine that doesn't have a PK.
-
- Novice
- Posts: 6
- Liked: 2 times
- Joined: Jan 13, 2016 8:53 pm
- Full Name: ASRIS
- Contact:
-
- Novice
- Posts: 6
- Liked: 2 times
- Joined: Jan 13, 2016 8:53 pm
- Full Name: ASRIS
- Contact:
Re: Restore sql table no primary or nonclustered
As it turns out you can't restore a table (with a different name) that has a Primary Key. You'll either have to remove/rename the PK or the original table before restoring.
We ended up renaming the original PK, then restored the table. Renamed the restored table's PK, and renamed the original one back.
We ended up renaming the original PK, then restored the table. Renamed the restored table's PK, and renamed the original one back.
Who is online
Users browsing this forum: No registered users and 76 guests