node-mssql/test/cleanup.sql at eb8086309f70cd17e0d004a34cda8c510e0a6c9b · tediousjs/node-mssql · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
if exists (select * from sys.procedures where name = '__test')
	exec('drop procedure [dbo].[__test]')

if exists (select * from sys.procedures where name = '__test2')
	exec('drop procedure [dbo].[__test2]')

if exists (select * from sys.procedures where name = '__test3')
	exec('drop procedure [dbo].[__test3]')

if exists (select * from sys.procedures where name = '__test5')
	exec('drop procedure [dbo].[__test5]')

if exists (select * from sys.procedures where name = '__test7')
	exec('drop procedure [dbo].[__test7]')

if exists (select * from sys.procedures where name = '__testDuplicateNames')
	exec('drop procedure [dbo].[__testDuplicateNames]')

if exists (select * from sys.procedures where name = '__testInputOutputValue')
	exec('drop procedure [dbo].[__testInputOutputValue]')

if exists (select * from sys.procedures where name = '__testRowsAffected')
	exec('drop procedure [dbo].[__testRowsAffected]')

if exists (select * from sys.procedures where name = '__testDelay')
	exec('drop procedure [dbo].[__testDelay]')

if exists (select * from sys.types where is_user_defined = 1 and name = 'MSSQLTestType')
	exec('drop type [dbo].[MSSQLTestType]')

if exists (select * from sys.tables where name = 'prepstm_test')
	exec('drop table [dbo].[tvp_test]')

if exists (select * from sys.tables where name = 'prepstm_test')
	exec('drop table [dbo].[prepstm_test]')

if exists (select * from sys.tables where name = 'tran_test')
	exec('drop table [dbo].[tran_test]')

if exists (select * from sys.tables where name = 'bulk_table')
	exec('drop table [dbo].[bulk_table]')

if exists (select * from sys.tables where name = 'bulk_table2')
	exec('drop table [dbo].[bulk_table2]')

if exists (select * from sys.tables where name = 'bulk_table3')
	exec('drop table [dbo].[bulk_table3]')

if exists (select * from sys.tables where name = 'bulk_table4')
	exec('drop table [dbo].[bulk_table4]')

if exists (select * from sys.tables where name = 'bulk_table5')
	exec('drop table [dbo].[bulk_table5]')

if exists (select * from sys.tables where name = 'rowsaffected_test')
	exec('drop table [dbo].[rowsaffected_test]')

if exists (select * from sys.tables where name = 'bignumbers')
	exec('drop table [dbo].[bignumbers]')

if exists (select * from sys.tables where name = 'streaming')
	exec('drop table [dbo].[streaming]')