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 vote151 views1 answer
Delete first row in sql
SQL
0 vote149 views1 answer
Get number of tables in database sql
SQL
1 vote153 views1 answer
Change table to innodb mysql
SQL
-1 vote145 views1 answer
Raise ImproperlyConfigured('mysqlclient 1.3.13 or newer is required; you have %s.' % Database.__version__) django.core.exceptions.ImproperlyConfigured: mysqlclient 1.3.13 or newer is required; you have 0.9.3.
SQL
0 vote142 views1 answer
Sql select duplicates based on two columns
SQL
1 vote146 views1 answer
Sql how to duplicate a table
SQL
0 vote159 views1 answer
Sql alter table order by
SQL
2 votes168 views1 answer
Sql string starts with
SQL
2 votes174 views3 answers
Postgres json to string
SQL
2 votes191 views1 answer
Remove foreign key constraints in postgres
SQL