Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Candidate versus Primary Key
Message
From
18/01/1999 22:16:12
 
 
To
18/01/1999 20:13:04
Ernie Veniegas
Micro System Solutions, Inc.
Calistoga, California, United States
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00177429
Message ID:
00177454
Views:
38
>Can you programmatically make a CANDIDATE key into a PRIMARY key so is you were to MODI TABLE afterwards, you'd see the old CANDIDATE type key now appearing as PRIMARY?

yup. Use syntax like this:

ALTER TABLE 'Mytable' ADD PRIMARY KEY myPK TAG MyPK

As when overwriting any index, if SET SAFETY is ON, you will get a dialog asking if the index should be overwritten.
Erik Moore
Clientelligence
Previous
Reply
Map
View

Click here to load this message in the networking platform