Home Forums Article Discussions Article Discussions by Author Discuss content posted by Mike DiRenzo Querying the INFORMATION_SCHEMA RE: Querying the INFORMATION_SCHEMA

  • September 29, 2011 at 2:59 am

    #1388228

    INFORMATION_SCHEMA.ROUTINES does not return triggers data, look here:

    ROUTINE_TYPE

    nvarchar(20)

    Returns PROCEDURE for stored procedures, and FUNCTION for functions.