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
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?
>
&
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
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
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
5 matches
Mail list logo