Getting Details about User-Defined Functions in master : sys.objects « System Tables Views « SQL Server / T-SQL Tutorial






  1. SQL Server / T-SQL Tutorial
  2. System Tables Views
  3. sys.objects
17>
18> SELECT
19>   *
20> FROM
21>   sysobjects
22> WHERE
23>     type IN('FN', 'TF')
24>   AND
25>     uid IN(user_id('system_function_schema'),
26>            user_id('dbo'))
27> GO
name
         id          xtype uid    info   status      base_schema_ver replinfo    parent_obj  crdate                  ftc
atid schema_ver  stats_schema_ver type userstat sysstat indexdel refdate                 version     deltrig     instrig
     updtrig     seltrig     category    cache
------------------------------------------------------------------------------------------------------------------------
-------- ----------- ----- ------ ------ ----------- --------------- ----------- ----------- ----------------------- ---
---- ----------- ---------------- ---- -------- ------- -------- ----------------------- ----------- ----------- -------
---- ----------- ----------- ----------- ------
linear_max
           318676233 FN         1      0           0               0           0           0 2007-10-22 04:26:43.660
   0           0                0 FN          0       0        0 2007-10-22 04:26:43.660           0           0
   0           0           0           0      0
fn_linear_max
           386152471 FN         1      0           0               0           0           0 2007-10-22 04:00:40.323
   0           0                0 FN          0       0        0 2007-10-22 04:00:40.323           0           0
   0           0           0           0      0

(2 rows affected)
1>
2>








27.10.sys.objects
27.10.1.Query sys.objects for object name
27.10.2.sys.objects INNER JOIN sys.columns
27.10.3.sys.objects catalog view contains a row for each object in the database.
27.10.4.Getting Details about User-Defined Functions in master