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