What is the query or table using which I can list the predefined functions. Instead of researching book I thought if there is a query I can see the list and try using each.
Printable View
What is the query or table using which I can list the predefined functions. Instead of researching book I thought if there is a query I can see the list and try using each.
I dont think it can be done through sql query, but it can be done through java jdbc programming which can extract all the predefined functions and display them
Thanks parthokonar1. I have tried programming as per your suggestion and could get the details.
select * from sysobjects where xtype like '%FN%'