SQL method to determine if a function stored procedure exists

Little scum · Posted on 2020-3-24 13:33:58

The following is an introduction to the code used to judge the existence of various resources under SQL, friends who need it can refer to it, I hope it can be helpful for you to learn SQL functions and databases.
library exists
if exists(select * from master.. sysdatabases where name=N'database name')
print 'exists'
else
print 'not exists'
---------------
-- Determine if the table name to be created exists
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[ table name]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
-- Delete table
drop table [dbo]. [Table Name]
GO
---------------
--Determine if the temporary table to be created exists
If Object_Id('Tempdb.dbo.#Test') Is Not Null
Begin
print 'exists'
End
Else
Begin
print 'does not exist'
End
---------------
-- Determine if the stored procedure name to be created exists
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[ Stored procedure name]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
-- Delete stored procedures
drop procedure [dbo]. [stored procedure name]
GO

Login is visible.

---------------
-- Determine if the view name to be created exists
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[ View Name]') and OBJECTPROPERTY(id, N'IsView') = 1)
-- Delete view
drop view [dbo]. [View Name]
GO
---------------
-- Determine if the function name to be created exists
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[ Function name]') and xtype in (N'FN', N'IF', N'TF'))
-- Delete function
drop function [dbo]. [Function Name]
GO
if col_length('table name', 'column name') is null
print 'does not exist'
select 1 from sysobjects where id in (select id from syscolumns where name='column name') and name='table name'

[Source] SQL method to determine if a function stored procedure exists

Related Posts

Sections viewed