Tag: primary-key


Found 230 results for 'primary-key'.


1) sql-server - SQL Server equivalent of Oracle USING INDEX clause
2) sql-server - Identity Column in Concurrency, Multithreading, Parallel Processing
3) sql-server - Unable to drop non-PK index because it is referenced in a foreign key constraint
4) postgresql - Email address unique or primary key?
5) postgresql - Retrieving all PK and FK
6) postgresql - What's better here - a single column or multicolumn primary key?
7) mysql - MySQL looking up more rows than needed (indexing issue)
8) postgresql - Working of indexes in PostgreSQL
9) mysql - How can I do 'insert if not exists' in MySQL?
10) postgresql - Is it reasonable to mark all columns but one as primary key?
11) mysql - How to design table to allow marking records as related to each other?
12) database-design - Whats the right table relationship for these entities?
13) mysql - How is it possible that a key of char+bigint has better performance than key of bigint+bigint?
14) database-design - Should every table have a single-field surrogate/artificial primary key?
15) mysql - Unique insert performance: Primary Key vs Unique Index
16) postgresql - Designing a database structure for companies and stock owners
17) sql-server - What are the pros and cons of using my customer codes as a primary key?
18) postgresql - Inserting in PostgreSQL Foreign Table Violates Primary Key Constraint10
19) mysql - Composite vs auto incrementing integer as Primary key
20) sql-server - Using a second table for unique key?
21) database-design - Two tables, one foreign key, and two primary keys
22) db2 - How can you tell if a table in DB2 has a Primary Key?
23) sql-server - How does SQL Server choose an index key for a foreign key reference?
24) sql-server - Ordering of table is based on Clustered index or non clustered primary key?
25) sql-server - Does auto increment on Primary Key prevent concurent inserts?
26) foreign-key - Foreign Keys to tables where primary key is not clustered index
27) postgresql - Automatic index creation for primary vs. foreign keys in Postgresql
28) sql-server - Change clustered index without dropping the primary key
29) postgresql - INSERT INTO table FROM SELECT * with nextval() specification
30) performance - MariaDB Uuid as Primary Key Performance Problem / Tweaks
31) mysql - Auto Increment Primary ID inserting random values
32) mysql - Is a 5+ column primary key bad for large (100 million+) table?
33) postgresql - UUID or BIGSERIAL Foreign Keys Postgres
34) primary-key - Relationship with a table without unique/primary key
35) mysql - Differences between "Unique Key" and "Primary Key"
36) ms-access - How can I allow part of a key to be null and enforce uniqueness of records with nulls?
37) mysql - MySQL Subquery returns more than one row
38) oracle - The four properties of a primary key
39) sql-server - Checking @@ROWCOUNT failing
40) mysql - Optimizing Queries HAVING COUNT and INSERT...ON DUPLICATE KEY UPDATE
41) database-design - Does a composite primary key break the first normal form?
42) sql-server - Why is it important for every table to have a primary key?
43) postgresql - How to add a serial ID to a table?
44) sql-server-2005 - Is there any tangible difference between a unique clustered index and a clustered primary key?
45) primary-key - Does a primary key contain exactly one Null value...?
46) mysql - Does it makes sense to index a primary key if it is not used?
47) sql-server - should I include the primary key in the clustered index in order to make it unique?
48) database-design - Is matriculation number a good primary key?
49) sql-server - primary key constraint Sorting
50) sql-server - Implications of removing unnecessary column from primary key