pedrotnascimento · May 8, 2017 22:20
diff --git a/SQL_gist_collections.sql b/SQL_gist_collections.sql
 -- checking intregrity of foreign key restriction
 select f.foreign_key 
 from foreignTable f left join primaryTable p 
 on p.primary_key = f.foreign_key 
 where p is null;
	-- checking intregrity of foreign key restriction
	select f.foreign_key
	from foreignTable f left join primaryTable p
	on p.primary_key = f.foreign_key
	where p is null;