AWr2HJxv

1IF EXISTS (SELECT 1 FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE='BASE TABLE' AND TABLE_NAME='mytablename') SELECT 1 AS res ELSE SELECT 0 AS res;
2
3IF OBJECT_ID (N'".$table_name."', N'U') IS NOT NULL SELECT 1 AS res ELSE SELECT 0 AS res;
4	
5IF (EXISTS (SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = 'TheSchema' AND  TABLE_NAME = 'TheTable'))
6BEGIN
7    --Do Stuff
8END
9	
10if OBJECT_ID('tempdb..#test') is not null
11 --- temp table exists
12	
13IF OBJECT_ID('*objectName*') IS NOT NULL
14	
15create procedure Table_Exists
16@tbl varchar(50)
17as
18return (select count(*) from sysobjects where type = 'U' and name = @tbl)
19go
20	
21DECLARE @Catalog VARCHAR(255)
22SET @Catalog = 'MyDatabase'
23
24DECLARE @Schema VARCHAR(255)
25SET @Schema = 'dbo'
26
27DECLARE @Table VARCHAR(255)
28SET @Table = 'MyTable'
29
30IF (EXISTS (SELECT * FROM INFORMATION_SCHEMA.TABLES   
31    WHERE TABLE_CATALOG = @Catalog 
32      AND TABLE_SCHEMA = @Schema 
33      AND TABLE_NAME = @Table))
34BEGIN
35   --do stuff
36END
37	
38IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Mapping_APCToFANavigator]') AND type in (N'U'))        
39BEGIN
40   ....
41END