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

Please read before make it Duplicate. I am trying to insert longitude and latitude values in SQLite… Read more Sqlite Table Constraint Unique And On Conflict Replace Usage

I use Entity Framework to access my SQL data. I have some constraints in the database schema and I … Read more Entity Framework: How To Properly Handle Exceptions That Occur Due To Sql Constraints

This question have been asked by several people but my problem seems to be different. Actually I ha… Read more Postgresql: Error Duplicate Key Value Violates Unique Constraint

I'm not sure whether I've found a bug in SQLite or whether I'm simply not using it corr… Read more Replace Path String In Sqlite Db Causes Unexpected Violated Unique Constraint

Using MS SQL Server, the following works fine: CREATE TABLE #temptable(mykey int primary key) INSE… Read more Shift (update) Unique Column Values In Postgresql

Suppose, I have the following table: CREATE TABLE 'user' ( id BIGINT PRIMARY KEY NO… Read more Unique Value Constraint Across Multiple Columns

Below are the two different attempts I have made in trying to achieve a multi-column unique constra… Read more SQLAlchemy Not Producing Proper SQL Statement For Multi Column UniqueConstraints

Given I have an exception of type 'java.sql.SQLIntegrityConstraintViolationException' Is it… Read more Given A 'java.sql.SQLIntegrityConstraintViolationException' Is It Possible To Determine Column('s) In Error