Hangfire clean script

GO

PRINT N'Dropping [HangFire].[FK_HangFire_State_Job]...';
GO

ALTER TABLE [HangFire].[State]

DROP CONSTRAINT [FK_HangFire_State_Job];
GO

PRINT N'Dropping [HangFire].[FK_HangFire_JobParameter_Job]...';
GO

ALTER TABLE [HangFire].[JobParameter]

DROP CONSTRAINT [FK_HangFire_JobParameter_Job];
GO

PRINT N'Dropping [HangFire].[Schema]...';
GO

DROP TABLE [HangFire].[Schema];
GO

PRINT N'Dropping [HangFire].[Job]...';
GO

DROP TABLE [HangFire].[Job];
GO

PRINT N'Dropping [HangFire].[State]...';
GO

DROP TABLE [HangFire].[State];
GO

PRINT N'Dropping [HangFire].[JobParameter]...';
GO

DROP TABLE [HangFire].[JobParameter];
GO

PRINT N'Dropping [HangFire].[JobQueue]...';
GO

DROP TABLE [HangFire].[JobQueue];
GO

PRINT N'Dropping [HangFire].[Server]...';
GO

DROP TABLE [HangFire].[Server];
GO

PRINT N'Dropping [HangFire].[List]...';
GO

DROP TABLE [HangFire].[List];
GO

PRINT N'Dropping [HangFire].[Set]...';
GO

DROP TABLE [HangFire].[Set];
GO

PRINT N'Dropping [HangFire].[Counter]...';
GO

DROP TABLE [HangFire].[Counter];
GO

PRINT N'Dropping [HangFire].[Hash]...';
GO

DROP TABLE [HangFire].[Hash];
GO

PRINT N'Dropping [HangFire].[AggregatedCounter]...';
GO

DROP TABLE [HangFire].[AggregatedCounter];
GO

PRINT N'Dropping [HangFire]...';
GO

DROP SCHEMA [HangFire];
GO

PRINT N'Update complete.';
GO

Source: stackoverflow.com

Similar codes

0 vote117 views2 answers
Mysql update two tables at once
SQL
2 votes128 views3 answers
Postgres create view
SQL
-2 votes107 views1 answer
How to open database
SQL
0 vote108 views1 answer
Using GROUP BY in MySQL Join Table
SQL
3 votes115 views2 answers
WhereIn SQL
SQL
0 vote124 views1 answer
Neo4j command to run script file
SQL
6 votes104 views4 answers
Eloquent to sql with bindings
SQL
18 votes111 views3 answers
Mysql add column with default value
SQL
5 votes118 views1 answer
Ignore duplicate rows in sqlite
SQL
0 vote115 views1 answer
Mysql 5.7 in centos 7
SQL