Re: Query to find Primary key?

2004-04-23 Thread Don
Check stored procedure, sp_pkeys at BOL. >Is it possible to find the column name of the primary key in a table from a >query? > > > >Select getPrimarykey() as Pkey > >From table > > > >FYI I'm running MS SQL2000 > > > >Thanks > > > > > > > >Mark W. Breneman >-Cold Fusion Developer >-Network

RE: Query to find Primary key?

2004-04-23 Thread Marlon Moyer
ctors Insurance Group phone: 972.687.9445 fax: 972.687.0607 mailto:[EMAIL PROTECTED] www.acig.com > -Original Message- > From: Thomas Chiverton [mailto:[EMAIL PROTECTED] > Sent: Friday, April 23, 2004 8:12 AM > To: CF-Talk > Subject: Re: Query to find Primary key? > &

Re: Query to find Primary key?

2004-04-23 Thread Thomas Chiverton
On Thursday 22 Apr 2004 19:41 pm, Marlon Moyer wrote: > SELECT    case isNullable when 1 then 0 else 1 end as required, What about non-nullable fields that aren't a PK ? -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44(0)1749 834997 email: [EMAIL PROTECTED] BlueFinger Limited Under

RE: Query to find Primary key?

2004-04-22 Thread Marlon Moyer
37 PM > To: CF-Talk > Subject: Query to find Primary key? > > Is it possible to find the column name of the primary key in a table from > a > query? > > > > Select getPrimarykey() as Pkey > > From table > > > > FYI I'm running MS SQL2000

Query to find Primary key?

2004-04-22 Thread Mark W. Breneman
Is it possible to find the column name of the primary key in a table from a query? Select getPrimarykey() as Pkey >From table FYI I'm running MS SQL2000 Thanks Mark W. Breneman -Cold Fusion Developer -Network Administrator   Vivid Media   [EMAIL PROTECTED]   www.vividmedia.com   608.270.9770