Web Wiz

  New Posts New Posts RSS Feed - MS-SQL Foreign Key - Re-create and Remove
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

MS-SQL Foreign Key - Re-create and Remove

 Post Reply Post Reply Page  <12
Author
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Wimborne
Status: Offline
Points: 9351
Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post Posted: 07 August 2017 at 8:47am
Why would you want to delete and recreate the primary and foreign keys?

As a DB Admin with over 20 years experience with SQL Server this is a VERY BAD idea and should NEVER be done.

I have removed the SQL that you posted to do this as it is extremely important that no-one does this as you will almost certainly end up with a broken Web Wiz Forums database that will give you stability and errors within your forum.
Back to Top
negrisoli View Drop Down
Groupie
Groupie


Joined: 13 April 2006
Location: Brazil
Status: Offline
Points: 75
Post Options Post Options   Thanks (0) Thanks(0)   Quote negrisoli Quote  Post ReplyReply Direct Link To This Post Posted: 07 August 2017 at 3:50pm
Bruce,

As a told you, my DB was very old and there were many differents fields, with different properties, like type, size, length, etc. and I needed to update them.

As you said me, these were not necessary, but I would like to have a clean DB and with the actual version.

Well, I'm very and extremely happy, because I did and it was a success !

Therefore, I've just shared this for help anothers.

It was only a post for share an idea, but if you don't think so, it is fine.

Sorry for that and thanks a lot for your concern.

Regards.
____________________________________________

Twitter: @negrisoli

www.helisport.com.br - O maior e melhor canal de Helimodelismo do Brasil
Back to Top
 Post Reply Post Reply Page  <12
  Share Topic   

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 11.10
Copyright ©2001-2017 Web Wiz Ltd.



Become a Fan on Facebook Follow us on Twitter Find us on Google+ Community Forums Web Wiz Blogs Web Wiz News
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Policy

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Unit B10, 9 Nimrod Way, East Dorset Trade Park, Wimborne, Dorset, BH21 7UH, United Kingdom.

Prices exclude VAT unless otherwise stated. VAT No. 988999105 - $, € prices shown as a guideline only.


Copyright ©2001-2017 Web Wiz Ltd. All rights reserved.