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 Underwood

RE: Query to find Primary key?

2004-04-23 Thread Marlon Moyer
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? On Thursday 22 Apr 2004 19:41 pm, Marlon Moyer

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 Administrator Vivid Media

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

RE: Query to find Primary key?

2004-04-22 Thread Marlon Moyer
Developer American Contractors Insurance Group phone: 972.687.9445 fax: 972.687.0607 mailto:[EMAIL PROTECTED] www.acig.com -Original Message- From: Mark W. Breneman [mailto:[EMAIL PROTECTED] Sent: Thursday, April 22, 2004 1:37 PM To: CF-Talk Subject: Query to find Primary key