Composite Unique Constraint SQL
<p>I have a table with parents and children, each record has a PRIMARY KEY id, a 'name', and a 'parent' that references another record's 'id'.</p>

<p>Can I enforce UNIQUE constraint on the 'name' among records that share a 'parent'?</p>