---

USE user300_db;
GO

/* =====================================================
   1. УДАЛЯЕМ ВСЕ ВНЕШНИЕ КЛЮЧИ, СВЯЗАННЫЕ С ТАБЛИЦАМИ
   ===================================================== */

DECLARE @sql NVARCHAR(MAX) = N'';

SELECT @sql = @sql +
    N'ALTER TABLE ' +
    QUOTENAME(OBJECT_SCHEMA_NAME(fk.parent_object_id)) + N'.' +
    QUOTENAME(OBJECT_NAME(fk.parent_object_id)) +
    N' DROP CONSTRAINT ' + QUOTENAME(fk.name) + N';' + CHAR(13)
FROM sys.foreign_keys fk
WHERE
    OBJECT_NAME(fk.parent_object_id) IN
    (
        'AttachedProduct',
        'Client',
        'ClientService',
        'DocumentByService',
        'Gender',
        'Manufacturer',
        'Product',
        'ProductPhoto',
        'ProductSale',
        'Service',
        'ServicePhoto',
        'Tag',
        'TagOfClient'
    )
    OR
    OBJECT_NAME(fk.referenced_object_id) IN
    (
        'AttachedProduct',
        'Client',
        'ClientService',
        'DocumentByService',
        'Gender',
        'Manufacturer',
        'Product',
        'ProductPhoto',
        'ProductSale',
        'Service',
        'ServicePhoto',
        'Tag',
        'TagOfClient'
    );

EXEC sp_executesql @sql;
GO


/* =====================================================
   2. УДАЛЯЕМ САМИ ТАБЛИЦЫ
   ===================================================== */

DROP TABLE IF EXISTS [dbo].[AttachedProduct];
DROP TABLE IF EXISTS [dbo].[DocumentByService];
DROP TABLE IF EXISTS [dbo].[ProductSale];
DROP TABLE IF EXISTS [dbo].[ProductPhoto];
DROP TABLE IF EXISTS [dbo].[ServicePhoto];
DROP TABLE IF EXISTS [dbo].[TagOfClient];
DROP TABLE IF EXISTS [dbo].[ClientService];

DROP TABLE IF EXISTS [dbo].[Product];
DROP TABLE IF EXISTS [dbo].[Client];
DROP TABLE IF EXISTS [dbo].[Service];

DROP TABLE IF EXISTS [dbo].[Manufacturer];
DROP TABLE IF EXISTS [dbo].[Gender];
DROP TABLE IF EXISTS [dbo].[Tag];
GO