distal-attribute
distal-attribute
distal-attribute
distal-attribute

View all functions for MSSQL Server

User, date Message
Written by Irbis
3 years ago
Category: General
9 posts since Tue, 03 Jan 12
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!
Written by ansgar
3 years ago
4936 posts since Fri, 07 Apr 06
MS SQL support is yet experimental. If you have advices on how to get functions via SQL query feel free to post that here.
Written by Irbis
3 years ago
9 posts since Tue, 03 Jan 12
this sql request return all functions in DB

USE TestDB

SELECT *
FROM sysobjects
WHERE
xtype = 'FN'

Written by ansgar
3 years ago
4936 posts since Fri, 07 Apr 06
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.
Written by Irbis
3 years ago
9 posts since Tue, 03 Jan 12
Great thanks!
 

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