- create database bdd /*nom de la base de donnée */
- on
- (name = bd_data,
- filename = "c:\bdd_data.mdf", /*l'emplacement de fichiere data */
- size = 60 mb) /*la taille de fichier data */
- log on /*pour le fichiere LOG */
- (name = bdd_log,
- filename = "c:\bdd_log.ldf",
- size = 60 mb)
- go
- use bdd
- create table client ( /*creation de la table client */
- numclt int ,
- nomclt char(20) not null,
- ville char(20) not null,
- constraint pk primary key(numclt))
- create table commande ( /*creation de la table commande */
- numcomd int not null,
- numclt int ,
- datecomd smalldatetime ,
- constraint fk foreign key(numclt) references client(numclt))
create database bdd /*nom de la base de donnée */
on
(name = bd_data,
filename = "c:\bdd_data.mdf", /*l'emplacement de fichiere data */
size = 60 mb) /*la taille de fichier data */
log on /*pour le fichiere LOG */
(name = bdd_log,
filename = "c:\bdd_log.ldf",
size = 60 mb)
go
use bdd
create table client ( /*creation de la table client */
numclt int ,
nomclt char(20) not null,
ville char(20) not null,
constraint pk primary key(numclt))
create table commande ( /*creation de la table commande */
numcomd int not null,
numclt int ,
datecomd smalldatetime ,
constraint fk foreign key(numclt) references client(numclt))