Skip to main content

Requêtes SQL Azure :

Migration V2->V3 (Lien vers la procédure) :

use master;
alter database quickeat set SINGLE_USER WITH ROLLBACK IMMEDIATE;
drop DATABASE quickeat;

Effacer la table contenant les Menus/Familles/Produits, etcetc... envoyés à la borne :

delete from Cart
delete from ProductCategory
delete from Category
delete from CustomValue
delete from CustomProduct
delete from Custom
delete from LinkedProduct
delete from MenuProduct
delete from Menu 
delete from ProductAllergen
delete from ReplacementProduct
delete from SuggestionProduct
delete from Product

Effacer complétement la BDD quickeat :

drop database quickeat