stored procedure to check if table present in sql

--Script for checking table in the given schema and create the same if not available
Declare @TabName VARCHAR(50) = 'Table1', @Schema VARCHAR(30) = 'dbo', @SQL VARCHAR(max) =''
IF NOT EXISTS (SELECT 1 from INFORMATION_SCHEMA.TABLES where TABLE_SCHEMA = @Schema AND TABLE_NAME = @TabName )
BEGIN
	SET @SQL = 'CREATE TABLE ' + @Schema + '.' + @TabName + '(col1 int);'
	EXEC (@SQL)
END
GO
--Check for table: Table1
select * FROM Table1

Mark This Response as Answer
--
Chandu
http://www.dotnetfunda.com/images/dnfmvp.gif

--CREATE/ALTER Here
CREATE PROCEDURE sp_ISTABLEEXISTED
(
@inputTABLENAME VARCHAR(50)
)
AS
BEGIN
DECLARE @CREATETABLE VARCHAR(MAX)
DECLARE @COLUMNAMES VARCHAR(MAX)
SET @CREATETABLE='[dbo].['+@inputTABLENAME+']'

IF EXISTS (SELECT * FROM sys.objects 
WHERE object_id = OBJECT_ID(@CREATETABLE) AND type in (N'U'))
BEGIN
PRINT 'Table Existed'
END

ELSE
BEGIN
SET @CREATETABLE=''
SET @CREATETABLE='CREATE TABLE '+@inputTABLENAME
SET  @COLUMNAMES='ID INT' --Specify columns Here 
EXEC(@CREATETABLE)
END
END

Thank you,
Govind