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'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 have three tables - file ( file_id int primary key filename text not null etc... ) product … Read more Postgres Unique Combination Constraint Across Tables

I have a postgresql table as CREATE TABLE IF NOT EXISTS table_name ( expiry_date DATE NOT NUL… Read more Applying Unique Constraint Of Date On Timestamp Column In Postgresql

I got the following table: CREATE TABLE `unsub_counts` ( `count_id` int(11) NOT NULL AUTO_INCREMEN… Read more Sql Drop Constraint Unique Not Working

create table Location ( id integer primary key(1, 1), latitude decimal(8,6), longitude decimal(9,6)… Read more Is There In Sql A Way To Enforce Unicity Of Undirected Edge?

I've had this come up a couple times in my career, and none of my local peers seems to be able … Read more Sql Can I Have A "conditionally Unique" Constraint On A Table?

Given the following three columns in a Postgres database: first, second, third; how can I create a … Read more Unique Constraint For Permutations Across Multiple Columns