Top "Primary-key" questions

A key is a set of attributes that is irreducibly unique and non-nullable within a table.

Information schema and Primary Keys

How do I just print out a 'primary key' for the column with the primary key? I get 'primary key' …

sql-server sql-server-2005 primary-key constraints information-schema
Do link tables need a meaningless primary key field?

I am working on a couple of link tables and I got to thinking (Danger Will Robinson, Danger) what are …

sql database-design primary-key
Composite DB keys with Entity Framework 4.0

The re-design for a large database at our company makes extensive use of composite primary keys on the database. Forgetting …

entity-framework primary-key composite-key
What are the design criteria for primary keys?

Choosing good primary keys, candidate keys and the foreign keys that use them is a vitally important database design task …

database database-design foreign-keys primary-key data-modeling
alter table drop column syntax error using sqlite

This is the schema of my table: create table LPCG(ID integer primary key, PCG text, Desc text, test text); …

sqlite primary-key alter-table
primary key is always indexed in sql server?

You can create a clustered index on a column other than primary key column if a nonclustered primary key constraint …

sql-server indexing primary-key clustered-index non-clustered-index
Android: Use UUID as primary key in SQLite

My app needs to get synced with other app users (on there own devices). I also want to support offline …

android performance sqlite primary-key uuid
Is it a good idea to use rowguid as unique key in database design?

SQL Server provides the type [rowguid]. I like to use this as unique primary key, to identify a row for …

sql-server database-design primary-key data-modeling
Should I use an int or a long for the primary key in an entity framework model

I am writing an MVC5 Internet application and I have a question about the id field for a model. Should …

c# model int primary-key entity-framework-6
Turnoff mysql unsafe statement warning

I am using log-error to write warning/errors into a file. When I perform INSERT IGNORE..SELECT statement, it just …

mysql insert primary-key ignore composite-primary-key