Check for existence of foreign key

[loydall]

Hi - I need to delete a foreign key programatically but, obviously, only if it exists.

I'm in MS SQL Server 2005.

I need to delete a Foreign called fkUserRoleID on a table called tblUsers.

Any ideas?

Thanks.

 

[bborissov]

IF EXISTS(SELECT * FROM INFORMATION_SCHEMA.REFERENTIAL_CONSTRAINTS WHERE Constraint_Name = 'fkUserRoleID')
   BEGIN
       ALTER TABLE dbo.??????????
	DROP CONSTRAINT fkUserRoleID
   END

Borislav Borissov
VFP9 SP1, SQL Server 2000/2005.
Microsoft MVP VFP