information_schema.routines.routine_schema

Note:

Database name associated with the routine.

Note:

Database name associated with the routine.

Note:

Name of the schema containing the function

Note:

Name of the schema containing the function

Note:

Always NULL.

Note:

Name of the schema that contains this function. ** Important ** Do not use INFORMATION_SCHEMA views to determine the schema of an object. INFORMATION_SCHEMA views only represent a subset of the metadata of an object. The only reliable way to find the schema of a object is to query the sys.objects catalog view.