Thursday, February 19, 2009

Mysql: Show user defined functions for some schema

If you have to look for the user defined functions in a mysql schema, here is the sample syntax to do so:

select
*
from
information_schema.ROUTINES
where
ROUTINE_SCHEMA=[schemaname] \G
PS: I use "\G" for better formatting, its not something which is necessary.

1 comment:

  1. Thanks Rakesh. God Bless you for this.

    ReplyDelete