FIND YOUR NEXT FEW LINES

Results for “composite”

Small, practical examples. Search by task or narrow things down below.

12 snippets foundClear filters
SQLSchema design & transactions

Create an index matching filter and ordering columns

SQL: Place the equality-filter column before the ordering column in this composite index.

SQL✓ Tested
SQL ServerSchema design & transactions

Create an index matching filter and ordering columns

SQL Server: Place the equality-filter column before the ordering column in this composite index.

SQL Server✓ Tested
PostgresSchema design & transactions

Create an index matching filter and ordering columns

Postgres: Place the equality-filter column before the ordering column in this composite index.

Postgres✓ Tested
SQLiteSchema design & transactions

Create an index matching filter and ordering columns

SQLite: Place the equality-filter column before the ordering column in this composite index.

SQLite✓ Tested
SQLConstraints & defaults

Make a pair of columns unique together

SQL: A composite primary key permits repeated individual values while forbidding a duplicate combination.

SQL✓ Tested
SQL ServerConstraints & defaults

Make a pair of columns unique together

SQL Server: A composite primary key permits repeated individual values while forbidding a duplicate combination.

SQL Server✓ Tested
PostgresConstraints & defaults

Make a pair of columns unique together

Postgres: A composite primary key permits repeated individual values while forbidding a duplicate combination.

Postgres✓ Tested
SQLiteConstraints & defaults

Make a pair of columns unique together

SQLite: A composite primary key permits repeated individual values while forbidding a duplicate combination.

SQLite✓ Tested
SQLConstraints & defaults

Reference a parent identified by two columns

SQL: A composite foreign key checks the complete referenced key rather than either column independently.

SQL✓ Tested
SQL ServerConstraints & defaults

Reference a parent identified by two columns

SQL Server: A composite foreign key checks the complete referenced key rather than either column independently.

SQL Server✓ Tested
PostgresConstraints & defaults

Reference a parent identified by two columns

Postgres: A composite foreign key checks the complete referenced key rather than either column independently.

Postgres✓ Tested
SQLiteConstraints & defaults

Reference a parent identified by two columns

SQLite: A composite foreign key checks the complete referenced key rather than either column independently.

SQLite✓ Tested