MySQL、Oracle、SqlServer查询函数是否存在

MySQL查询函数 

-- 查询函数
SHOW FUNCTION STATUS WHERE `name` = '函数名称'

-- 查询存储过程
SHOW PROCEDURE STATUS

 Oracle查询函数

-- 查询函数
SELECT * from dba_source where type = 'FUNCTION' AND NAME = '函数名'

-- 查询存储过程
SELECT * from dba_source where type = 'PROCEDURE' AND NAME = '名称'

SqlServer查询函数

--查询函数
SELECT * FROM sys.objects WHERE type = 'FN' AND name = 'get_random_fun';




--创建视图
CREATE VIEW vwRand
AS
SELECT RAND() AS RandValue

--判断函数是否存在并创建

IF EXISTS ( SELECT * FROM sys.objects WHERE type = 'FN' AND name = 'get_random_fun' )
         DROP FUNCTION get_random_fun
        GO  
	CREATE FUNCTION get_random_fun ( ) RETURNS INT AS BEGIN
	DECLARE
		@rad INT SELECT
		@rad = 10000 * RandValue 
	FROM
		vwRand;
	RETURN @rad 
	END