Mostrando entradas con la etiqueta foreign keys. Mostrar todas las entradas
Mostrando entradas con la etiqueta foreign keys. Mostrar todas las entradas

Listar las tablas que no tienen claves foranea (FK)

DECLARE @TablasConFk TABLE
(
[object_Id] int
)

INSERT @TablasConFk ( [object_Id] )
SELECT referenced_object_id
FROM sys.foreign_keys
UNION
SELECT [parent_object_id]
FROM sys.foreign_keys

SELECT name as Tabla
FROM sys.objects obj
LEFT OUTER JOIN @TablasConFk conFk ON ( obj.[object_id] = conFk.[object_Id] )
WHERE type_desc = 'USER_TABLE'
AND conFk.[object_Id] IS NULL
ORDER BY Tabla