Re: [NF] Changing Primary Key Column

2006-07-21 Thread Andy Davies
--create table custx (name varchar(40), uniquref int) alter table custx alter column uniquref int not null GO alter table custx ADD CONSTRAINT [cust_pk] primary key clustered (uniquref) Andrew Davies  MBCS CITP   - AndyD    8-)#

[NF] Changing Primary Key Column

2006-07-20 Thread Dave Crozier
Hi all, Sorry to be a real pain in the A*SE today. I'm really cracking on with my VFP - SQLExpress - SQLMobile - PDA Application project now that I can see/manipulate the data in SQLExpress, however I've come across a small problem that has foxed me for a couple of hours. I need to add a Primary

RE: [NF] Changing Primary Key Column

2006-07-20 Thread David Stevenson
: Thursday, July 20, 2006 11:13 AM To: [EMAIL PROTECTED] Subject: [NF] Changing Primary Key Column Hi all, Sorry to be a real pain in the A*SE today. I'm really cracking on with my VFP - SQLExpress - SQLMobile - PDA Application project now that I can see/manipulate the data in SQLExpress, however