Lab Sql

With provided schema i want to somehow enforce that there is unique reserved_seat:seat_id per showi… Read more Enforce Composite Unique Constraint That Depends On Parent Column Value

I've a PK constraint - a clustered index on two columns - which I am in the process of dropping… Read more What Happens When I Drop A Clustered Primary Key In Sql 2005

I'm using Sybase ASE 15.5 and a stranger to this database. Straight to the point--> I'm … Read more Sql Query To Get Primary Keys For All Tables In Sybase Ase 15.x Along With Column Names

I want to include a check constraint on a table between the primary key of the latter and the prima… Read more Oracle Sql Check Constraint != Other Table

I tried to add a Check Constraint and I have only failed so far. What would be the way to get aroun… Read more Check Constraint - Subqueries Are Not Allowed In This Context

a USER is a PERSON and a PERSON has a COMPANY - user -> person is one-to-one, person -> compa… Read more Implementing Unique Across Linked Tables In Mysql

Table: Relatives emp_id dep_id(composite primary key) We have to restrict one employee to three … Read more Can I Have A Constraint On Count Of Distinct Values In A Column In Sql?

I have written the following constraint for a column I've called 'grade': CONSTRAINT gr… Read more Can You Replace Or Update A Sql Constraint?