delete all hangfire tables sql query

Solutions on MaxInterview for delete all hangfire tables sql query by the best coders in the world

showing results for - "delete all hangfire tables sql query"
Maelia
07 May 2017
1GO
2PRINT N'Dropping [HangFire].[FK_HangFire_State_Job]...';
3GO
4ALTER TABLE [HangFire].[State] DROP CONSTRAINT [FK_HangFire_State_Job];
5GO
6PRINT N'Dropping [HangFire].[FK_HangFire_JobParameter_Job]...';
7GO
8ALTER TABLE [HangFire].[JobParameter] DROP CONSTRAINT [FK_HangFire_JobParameter_Job];
9GO
10PRINT N'Dropping [HangFire].[Schema]...';
11GO
12DROP TABLE [HangFire].[Schema];
13GO
14PRINT N'Dropping [HangFire].[Job]...';
15GO
16DROP TABLE [HangFire].[Job];
17GO
18PRINT N'Dropping [HangFire].[State]...';
19GO
20DROP TABLE [HangFire].[State];
21GO
22PRINT N'Dropping [HangFire].[JobParameter]...';
23GO
24DROP TABLE [HangFire].[JobParameter];
25GO
26PRINT N'Dropping [HangFire].[JobQueue]...';
27GO
28DROP TABLE [HangFire].[JobQueue];
29GO
30PRINT N'Dropping [HangFire].[Server]...';
31GO
32DROP TABLE [HangFire].[Server];
33GO
34PRINT N'Dropping [HangFire].[List]...';
35GO
36DROP TABLE [HangFire].[List];
37GO
38PRINT N'Dropping [HangFire].[Set]...';
39GO
40DROP TABLE [HangFire].[Set];
41GO
42PRINT N'Dropping [HangFire].[Counter]...';
43GO
44DROP TABLE [HangFire].[Counter];
45GO
46PRINT N'Dropping [HangFire].[Hash]...';
47GO
48DROP TABLE [HangFire].[Hash];
49GO
50PRINT N'Dropping [HangFire].[AggregatedCounter]...';
51GO
52DROP TABLE [HangFire].[AggregatedCounter];
53GO
54PRINT N'Dropping [HangFire]...';
55GO
56DROP SCHEMA [HangFire];
57GO
58PRINT N'Update complete.';
59GO
Carlos
22 Aug 2018
1TRUNCATE TABLE [HangFire].[AggregatedCounter]
2TRUNCATE TABLE [HangFire].[Counter]
3TRUNCATE TABLE [HangFire].[JobParameter]
4TRUNCATE TABLE [HangFire].[JobQueue]
5TRUNCATE TABLE [HangFire].[List]
6TRUNCATE TABLE [HangFire].[State]
7DELETE FROM [HangFire].[Job]
8DBCC CHECKIDENT ('[HangFire].[Job]', reseed, 0)
9UPDATE [HangFire].[Hash] SET Value = 1 WHERE Field = 'LastJobId'