Query MSSQL Tutorial

  1. Home
  2. MSSQL Tutorial
  3. Query
  4. IF EXISTS
3>
4> CREATE PROCEDURE spTableExists
5>  @TableName VarChar(128)
6> AS
7>  IF EXISTS(SELECT * FROM sysobjects WHERE name = @TableName)
8>  PRINT @TableName + ' exists'
9> GO
1>
2>
3> drop proc spTableExists;
4> GO
1>
2>