IF NOT exists( select name from sys.databases WHERE name =N'GestionStock')
    CREATE DATABASE GestionStock;
Go

USE GestionStock
Go

IF OBJECT_ID('stock','U') IS NULL

    CREATE TABLE stock(
    id_stock int primary key,
    produit varchar(50),
    quantite_stocke int
    )

IF OBJECT_ID('commandes','U') IS NULL
    CREATE TABLE commandes(
    id_commande int primary key,
    id_stock int foreign key references stock(Id_Stock),
    Quantite_commande int)

insert into stock values(1,'voiture',500)
insert into stock values(2,'moto',1000)
insert into stock values(3,'camion',10)