Finding modify date of a function is SQL Server

You can retrieve create dates and modification dates from sys.objects. You can use the following query to retrieve the necessary details:

select * from sys.objects where (type='IF' OR type='TF' or type='FN') and name = '';

Please note that sys.objects does not show DDL triggers, because they are not schema-scoped. All triggers, both DML and DDL, are found in sys.triggers. sys.triggers supports a mixture of name-scoping rules for the various kinds of triggers.

Tags: Microsoft, SQL, Server, Database, Oracle, University, College

Related