Specification of the primary key of the employee table as a column-level constraint : Primary key « Constraints « SQL Server / T-SQL

1.	Aggregate Functions
2.	Analytical Functions
3.	Constraints
4.	Cursor
5.	Data Set
6.	Data Type
7.	Database
8.	Date Timezone
9.	Index
10.	Insert Delete Update
11.	Math Functions
12.	Select Query
13.	Sequence
14.	Store Procedure Function
15.	String Functions
16.	Subquery
17.	System
18.	Table
19.	Table Joins
20.	Transact SQL
21.	Transaction
22.	Trigger
23.	View
24.	XML

SQL Server / T-SQL » Constraints » Primary key

Specification of the primary key of the employee table as a column-level constraint



1> -- Specification of the primary key of the employee table as a column-level constraint.

2> CREATE TABLE employee

3>             (emp_no    INTEGER NOT NULL CONSTRAINT prim_empl PRIMARY KEY,

4>              emp_fname CHAR(20) NOT NULL,

5>              emp_lname CHAR(20) NOT NULL,

6>              dept_no   CHAR(4) NULL)

7> GO

1> drop table employee

2> GO

1>

Related examples in the same category

1.	Combine two columns as the primary key
2.	Define Primary key in table creation command

java2s.com | Contact Us | Privacy Policy

All other trademarks are property of their respective owners.