Ybu6ya7v

1IF TABLE EXISTS 
2    DROP IT AND CREATE IT AGAIN
3ELSE
4    CREATE IT
5	
6CREATE TABLE ##CLIENTS_KEYWORD(client_id int)     
7CREATE TABLE ##TEMP_CLIENTS_KEYWORD(client_id int)
8	
9DROP TABLE IF EXISTS ##CLIENTS_KEYWORD
10	
11IF OBJECT_ID('tempdb..##CLIENTS_KEYWORD') IS NOT NULL
12  /*Then it exists*/
13  DROP TABLE ##CLIENTS_KEYWORD
14
15CREATE TABLE ##CLIENTS_KEYWORD
16  (
17     client_id INT
18  )
19	
20IF OBJECT_ID('tempdb..##CLIENTS_KEYWORD') IS NOT NULL
21  TRUNCATE TABLE ##CLIENTS_KEYWORD
22ELSE
23  CREATE TABLE ##CLIENTS_KEYWORD
24    (
25       client_id INT
26    )
27	
28if object_id('tempdb..##clients_keyword') is not null
29    drop table ##clients_keyword
30	
31IF OBJECT_ID('tempdb..##CLIENTS_KEYWORD') IS NOT NULL
32    BEGIN
33       DROP TABLE ##CLIENTS_KEYWORD
34
35       CREATE TABLE ##CLIENTS_KEYWORD(client_id int)
36
37    END
38ELSE
39   CREATE TABLE ##CLIENTS_KEYWORD(client_id int) 
40
41IF OBJECT_ID('tempdb..##TEMP_CLIENTS_KEYWORD') IS NOT NULL
42    BEGIN
43       DROP TABLE ##TEMP_CLIENTS_KEYWORD
44
45       CREATE TABLE ##TEMP_CLIENTS_KEYWORD(client_id int)
46
47    END
48ELSE
49   CREATE TABLE ##TEMP_CLIENTS_KEYWORD(client_id int)
50	
51IF OBJECT_ID('tempdb..##CLIENTS_KEYWORD') IS NOT NULL
52   DROP TABLE ##CLIENTS_KEYWORD
53
54CREATE TABLE ##CLIENTS_KEYWORD(client_id int) 
55
56IF OBJECT_ID('tempdb..##TEMP_CLIENTS_KEYWORD') IS NOT NULL
57   DROP TABLE ##TEMP_CLIENTS_KEYWORD
58
59CREATE TABLE ##TEMP_CLIENTS_KEYWORD(client_id int)