[ACCEPTED]-What does keyword CONSTRAINT do in this CREATE TABLE statement-sql

Accepted answer

Score: 15

Country_key is simply giving a name to the 5 constraint. If you do not do this the name 4 will be generated for you. This is useful 3 when there are several constraints on the 2 table and you need to drop one of them.

As 1 an example for dropping the constraint:

ALTER TABLE PopByCountry DROP CONSTRAINT Country_Key

Score: 3

If you omit CONSTRAINT Contry_Key from the 6 statement, SQL server will generate a name 5 for your PRIMARY KEY constraint for you 4 (the PRIMARY KEY is a type of constraint).

By 3 specifically putting CONSTRAINT in the 2 query you are essentially specifying a name 1 for your primary key constraint.

Source: stackoverflow.com

[ACCEPTED]-What does keyword CONSTRAINT do in this CREATE TABLE statement-sql

Access second result set of stored procedure with SQL or other work-around? Python\pyodbc

Django: Paginator + raw SQL query

Django filter queryset on "tuples" of values for multiple columns

How to calculate a MSSQL query execution time using python

Pandas equivalent to SQL window functions

SQLAlchemy - order_by on relationship for join table

Wildcards in column name for MySQL

How can I prevent SQL injection in PYTHON-DJANGO?

Can't insert single column value in python using MySQL

How to use OR using Django's model filter system?