Checking Table dependancies fron Store Procedure

[Sanjay80]

I want to Update one table but same time if any column from table ishaving Primary kay or Foreign Kay it should not allow me to do so. I am writting Stored Procedure

[iburyak]

Try this:

[PHP]If not exists(select b.name
from sysconstraints a
join sysobjects b on a.constid = b.id
where a.id = object_id('table_name_here'))

BEGIN


-- your update here.

END[/PHP]

[iburyak]

Correction

[PHP]If not exists(select b.name
from sysconstraints a
join sysobjects b on a.constid = b.id
where a.id = object_id('table_name_here')
and b.xtype in ('PK', 'F'))

BEGIN


-- your update here.

END [/PHP]