I recently moved my website to new hosting. At that point I turned off all membership login etc because the site security needed improving and have not added or updated the customer tables from that point.
I am using a local copy of 2012 express to access the hosted database
I now want to turn the customer processing on.
There is now a problem with the customer table. It has all the existing values from before but the CustomerID (the primary key) does not have the identity key and values set so I am unable to add new customers.
I can change the settings to automatically create a new customer table value but I cannot save them back to the table because I need to drop the table before saving the values I have set.
What do I have to do to drop the table.