SQL文法基礎

--建立表的同時建立約束

use tempdb

if Object_ID('testDB') is not Null

drop table testDB;

CREATE TABLE testDB(

ID INT IDENTITY(1,1) NOT NULL,

[Name] NVARCHAR(50) NOT NULL ,

Description NVARCHAR(2000) NOT NULL,

CreateDate Datetime Default(getDate()),

CONSTRAINT PK_ID PRIMARY KEY CLUSTERED (ID ASC),

CONSTRAINT CHK_ID Check (ID between 1 and 1000)

)

--刪除約束

use tempdb

alter Table testDB Drop Constraint PK_ID

--修改約束

use tempdb

alter Table testDB Add Constraint PK_ID Primary key CLUSTERED(ID ASC)

1:約束格式

CONSTRAINT Constraint_name Constraint_type(col)

Constraint_type:check,Primary key,Foreign key,unique