Web Wiz - Solar Powered Eco Web Hosting

  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: Bournemouth
Status: Offline
Points: 9791
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: 79
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.
Back to Top
 Post Reply Post Reply Page  <12

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.07
Copyright ©2001-2024 Web Wiz Ltd.


Become a Fan on Facebook Follow us on X Connect with us on LinkedIn Web Wiz Blogs
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: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

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

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