[Solved] Can referential integrity be enforced using alter table?
I’m not sure I understand why you think this is better than foreign keys, but yes, you can implement referential integrity in other (inferior) ways. These will be slower than doing it right and fixing the design. Check constraint + UDF CREATE FUNCTION dbo.IsItAValidWeight(@Son_Weight int) RETURNS bit WITH SCHEMABINDING AS BEGIN RETURN ( SELECT CASE … Read more