Tag Info

New answers tagged


Like @ypercube commented, check the CREATE TABLE page of the manual: There are three match types: MATCH FULL, MATCH PARTIAL, and MATCH SIMPLE (which is the default). MATCH FULL will not allow one column of a multicolumn foreign key to be null unless all foreign key columns are null; if they are all null, the row is not required to have a match in ...


Thanks @Joel Brown, your comment pointed me in the direction I needed to go. This is what I ended up with, which satisfies all of my requirements: CREATE TABLE RuleGroups ( ID INT NOT NULL IDENTITY(1,1) CONSTRAINT pk_rulegroups PRIMARY KEY (ID) ) CREATE TABLE Rules ( ID INT NOT NULL IDENTITY(1,1), GroupID INT NOT NULL, ...

Top 50 recent answers are included