Find constraints connected to table.

childTables.sql

SELECT
	[parentTable].name AS parentTable,
	[childTable].name AS childTable,
	[constraint].name AS [constraint],
	[parentColumn].name AS parentColumn,
	[childColumn].name AS childColumn
FROM sys.foreign_key_columns as fk
INNER JOIN sys.objects AS [constraint] ON [constraint].[object_id]=[fk].constraint_object_id
INNER JOIN sys.objects AS [parentTable] ON [parentTable].[object_id]=[fk].[referenced_object_id]
INNER JOIN sys.columns as [parentColumn] ON [parentColumn].[column_id]=[fk].[referenced_column_id] AND [parentColumn].[object_id]=[fk].[referenced_object_id]
INNER JOIN sys.objects AS [childTable] ON [childTable].[object_id]=[fk].[parent_object_id]
INNER JOIN sys.columns AS [childColumn] ON [childColumn].[column_id]=[fk].[parent_column_id] AND [childColumn].[object_id]=[fk].[parent_object_id]
WHERE [parentTable].[name]='Part'
ORDER BY [parentTable].name,[childTable].name,[constraint].name;