View all functions for MSSQL Server

9 posts
[expired user #6134]'s profile image [expired user #6134] posted 12 years ago in General Permalink
Folks,
I am use build 6.0.0.4007
How to I can view all functions in database?(MSSQL Server)
I see procedures, tables and views
I don't see any functions in database

Please help me!
Thaks in advance!
10137 posts
ansgar's profile image ansgar posted 12 years ago Permalink
MS SQL support is yet experimental. If you have advices on how to get functions via SQL query feel free to post that here.
9 posts
[expired user #6134]'s profile image [expired user #6134] posted 12 years ago Permalink
this sql request return all functions in DB

USE TestDB
SELECT *
FROM sysobjects
WHERE
xtype = 'FN'
Code modification/commit from ansgar.becker, 12 years ago, revision 6.0.0.4021
Show functions and triggers in MS SQL. See http://www.heidisql.com/forum.php?t=9671
10137 posts
ansgar's profile image ansgar posted 12 years ago Permalink
r4021 now lists functions as well as triggers. Please note that editing a function or trigger in MS SQL is not yet supported by HeidiSQL, which is basically caused by many differences between MS SQL and MySQL.
9 posts
[expired user #6134]'s profile image [expired user #6134] posted 12 years ago Permalink
Great thanks!

Please login to leave a reply, or register at first.