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

View all functions for MSSQL Server

Irbis posted 3 years ago in General
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!
ansgar posted 3 years ago
MS SQL support is yet experimental. If you have advices on how to get functions via SQL query feel free to post that here.
Irbis posted 3 years ago
this sql request return all functions in DB

USE TestDB

SELECT *
FROM sysobjects
WHERE
xtype = 'FN'

ansgar posted 3 years ago
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.
Irbis posted 3 years ago
Great thanks!

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