SQL Constraint Örnek #1

Create Table Ulkeler
(
    UlkeNo Int Identity,
    UlkeAdi Varchar(50) NOT NULL
    Constraint PK_Ulkeler_UlkeNo Primary Key(UlkeNo),
    Constraint AN_Ulkeler_UlkeAdi Unique(UlkeAdi)
)
Go

Create Table Iller
(
    IlNo Int Identity,
    IlAdi Varchar(50) NOT NULL,
    UlkeNo Int
    Constraint PK_Iller_IlNo Primary Key(IlNo),
    Constraint FK_Iller_UlkeNo Foreign Key(UlkeNo) References Ulkeler(UlkeNo) On Delete Cascade
)
Go

Create Table Ilceler
(
    IlceNo Int Identity,
    IlceAdi Varchar(50),
    IlNo Int,
    IlcePostaKodu Varchar(5) NOT NULL,
    Constraint PK_Ilceler_IlceNo Primary Key(IlceNo),
    Constraint FK_Ilceler_IlNo Foreign Key(IlNo) References Iller(IlNo)
)

Create Table Calisanlar
(
    CalisanNo Int Identity,
    CalisanTc Varchar(11),
    CalisanAdi Varchar(50) NOT NULL,
    CalisanSoyadi Varchar(50) NOT NULL,
    CalisanAdresi Varchar(125) NOT NULL,
    CalisanTelefon Varchar(20) NOT NULL,
    CalisanIlcesi Int
    Constraint PK_Calisanlar_CalisanNo Primary Key(CalisanNo),
    Constraint FK_Calisanlar_Ilce Foreign Key(CalisanIlcesi) References Ilceler(IlceNo),
    Constraint CK_Calisanlar_CalisanTc
    Check(CalisanTc Like '[1-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9]')
)
Go