Top "Constraints" questions

A constraint is a condition that has to be fulfilled in a given context.

Adding named foreign key constraints in a SQL Create statement

I currently have: CREATE TABLE galleries_gallery ( id INT NOT NULL PRIMARY KEY IDENTITY, title NVARCHAR(50) UNIQUE NOT NULL, description …

sql sql-server postgresql constraints create-table
Modify unique constraint in Oracle

I need to update an existing constraint in Oracle database to add a new column there. ALTER TABLE MY_PARTNER_…

sql oracle constraints ora-00933
PostgreSQL: default constraint names

When creating a table in PostgreSQL, default constraint names will assigned if not provided: CREATE TABLE example ( a integer, b …

postgresql naming-conventions constraints
Scrollview inside constraint layout does not scroll to the bottom of the parent constraint

I have a form which has around 12/13 fields. I used a Scrollview inside a constraint layout. Below is the hierarchy …

android android-layout constraints scrollview android-constraintlayout
How to set constraints on generic types in Java?

I have a generic class: public class ListObject<T> { // fields protected T _Value = null; // .. } Now I want to …

java generics constraints
Conditional SQLite check constraint?

I have a table defined by the following SQL: CREATE TABLE test ( id integer PRIMARY KEY NOT NULL UNIQUE, status …

sql sqlite constraints
T-SQL: How do I create a unique key that is case sensitive?

How do I create a unique constraint on a varchar field that is case sensitive (SQL Server 2005)? Currently my constraint …

sql sql-server tsql constraints
How do I DROP a constraint from a sqlite (3.6.21) table?

I have the following table: CREATE TABLE child( id INTEGER PRIMARY KEY, parent_id INTEGER CONSTRAINT parent_id REFERENCES parent(…

sqlite constraints ddl
Alter a nonunique index to a unique index

I have a few non-unique constraints that I want to alter into unique constraints ( business rules have changed since the …

oracle oracle10g constraints unique-constraint
C# Generic constraints to include value types AND strings

I'm trying to write an extension method on IEnumerable that will only apply to value types and strings. public static …

c# string generics constraints value-type