Solved

Change Ref ID on all Tables

Posted on 1998-08-02
3
191 Views
Last Modified: 2010-03-19
What is the best way to change the Ref ID fields on all tables???
0
Comment
Question by:kachan
  • 2
3 Comments
 
LVL 3

Accepted Solution

by:
gmoriak earned 50 total points
ID: 1089359
Drop your foreign keys.  Write and run scripts to renumber your Id's .  Then readd your foreign keys

What is the reason for doing this?  There may be better alternatives both for renumbering and to renumbering.
0
 

Author Comment

by:kachan
ID: 1089360
In fact what I want to change is the Ref ID which is the the key value of all tables.. After getting advices from all experts, I think I would like to do it in other way rather changing this so important field.

Thanks for your input.
0
 

Author Comment

by:kachan
ID: 1089361
In fact what I want to change is the Ref ID which is the the key value of all tables.. After getting advices from all experts, I think I would like to do it in other way rather changing this so important field.

Thanks for your input.
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Introduced in Microsoft SQL Server 2005, the Copy Database Wizard (http://msdn.microsoft.com/en-us/library/ms188664.aspx) is useful in copying databases and associated objects between SQL instances; therefore, it is a good migration and upgrade tool…
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Viewers will learn how the fundamental information of how to create a table.

708 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now