sql 遍历 数据库表，找外键引用

declare @tableName varchar(50)

declare @mytemp table (name nvarchar(50))

set rowcount 0

insert into @mytemp
select name    from   sysobjects   where   type='U' 
set rowcount 1

select @tableName = name from @mytemp

while @@rowcount <> 0
begin
    set rowcount 0

select @tableName
SELECT  @tableName as 'tablename', OBJECT_SCHEMA_NAME(parent_object_id) AS SchemaName,
 OBJECT_NAME(parent_object_id) AS TableName ,
Name FROM sys.foreign_keys  WHERE referenced_object_id=OBJECT_ID(@tableName)

    delete @mytemp where name = @tableName
    set rowcount 1
    select @tableName = name from @mytemp
end
set rowcount 0

declare @tableName varchar(50)

declare @mytemp table (name nvarchar(50))

set rowcount 0

insert into @mytemp
select name    from   sysobjects   where   type='U'
set rowcount 1

select @tableName = name from @mytemp

while @@rowcount <> 0
begin
    set rowcount 0

select @tableName
SELECT  @tableName as 'tablename', OBJECT_SCHEMA_NAME(parent_object_id) AS SchemaName,
 OBJECT_NAME(parent_object_id) AS TableName ,
Name FROM sys.foreign_keys  WHERE referenced_object_id=OBJECT_ID(@tableName)

    delete @mytemp where name = @tableName
    set rowcount 1
    select @tableName = name from @mytemp
end
set rowcount 0