Post reply

table changes

  • August 27, 2003 at 7:19 am

    #160562

    is there a way to change all dependiences when a table name change is made?

  • August 27, 2003 at 7:22 am

    #471594

    sp_depends

  • August 27, 2003 at 7:32 am

    #471596

    Select distinct

    db_name() as CurrentDatabase,

    object_Name(d.depid) As TableName,

    s.name + '.' + o.name As Dependency,

    substring(v.name, 5, 16) As Type

    From sysobjects o

    Inner Join master.dbo.spt_values v On o.xtype = SubString(v.name,1,2) Collate database_default And v.type = 'O9T'

    Inner Join sysdepends d On o.id = d.id

    Inner Join sysusers s On o.uid = s.uid

    Where d.depid <> 0

    And deptype < 2

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply