Back to OIM Explorer

dbo.QBM_FGIObjectIsDropable

Scalar FunctionSQL_SCALAR_FUNCTIONSandbox DB

Scalar Function.

Source: sandbox-db sys.sql_modules

Source size: 314 characters

Interpretation

  • Database function. Usually supports views, validation, or calculated predicates; look at referenced-by entries for callers.

Relations

  • No extracted relations.

Typed Edges

  • No typed edges extracted for this source.

References

  • No direct source references extracted.

Referenced By

Complete Source

SQL17 lines
1CREATE FUNCTION dbo.QBM_FGIObjectIsDropable(2  @SchemaID int3) RETURNS int4AS5BEGIN6  DECLARE @erg int7  SELECT @erg = 18  IF EXISTS(9    SELECT TOP 1 110    FROM sys.schemas11    WHERE12      schema_id = @SchemaID AND name IN(N 'sys', N 'INFORMATION_SCHEMA' collate database_default))13  BEGIN14    SELECT @erg = 015  END16  RETURN(@erg)17END
Open raw exported source
SQL ยท Raw4 lines
1  create   function dbo.QBM_FGIObjectIsDropable (@SchemaID int) returns int  as begin  declare @erg int select @erg = 1 if exists (select top 1 21 from sys.schemas where schema_id = @SchemaID and name in ( N'sys' , N'INFORMATION_SCHEMA' collate database_default ) ) begin select @erg = 0 end return3(@erg) end 4