Software Development : A dizzy job...keeping abreast and being competitive is a 24X7 involvement
Nov 23, 2004
Nov 8, 2004
Nov 7, 2004
Nov 4, 2004
Nov 2, 2004
Sep 8, 2004
Hey did u know about this "To find which objects are referencing a Table in SQL or Table
dependency ?"
>> sp_depends 'object name'
>>sp_depends tblAFDUserMaster (no quotes)
>>select object_name(constid) as constraint_name, object_name(fkeyid) as table_name
from sysreferences
where object_name(rkeyid) = 'your table name' (with quotes)
>>select object_name(constid) as constraint_name, object_name(fkeyid) as table_name
from sysreferences
where object_name(rkeyid) = 'TABLE_BROKER'
>>Select id from sysobjects where name='tblAFDUserMaster'
>>select object_name(constid) as constraint_name,object_name(fkeyid) as table_name
from sysreferences
where object_name(rkeyid) in
(select distinct object_name(rkeyid) as ConstraintName
from sysreferences
where fkey1>1)
Aug 30, 2004
SOME COOL SQL SERVER STUFF
sp_depends 'dbo.M_Artifact'
select object_name(constid) as constraint_name,
object_name(fkeyid) as table_name
from sysreferences
where object_name(rkeyid) in (select distinct object_name(rkeyid) as ConstraintName
from sysreferences
where fkey1>1)
Select * from sysreferences
select object_name(2071678428)
Select
select distinct object_name(rkeyid) as ConstraintName
from sysreferences
where fkey1>1
sp_depends 'dbo.M_Artifact'
select object_name(constid) as constraint_name,
object_name(fkeyid) as table_name
from sysreferences
where object_name(rkeyid) in (select distinct object_name(rkeyid) as ConstraintName
from sysreferences
where fkey1>1)
Select * from sysreferences
select object_name(2071678428)
Select
select distinct object_name(rkeyid) as ConstraintName
from sysreferences
where fkey1>1
Jul 24, 2004
Jul 23, 2004
Subscribe to:
Posts (Atom)