Mega Code Archive

 

Categories / MSSQL Tutorial / System Tables Views

 

Getting Details about User-Defined Functions in master

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>