Function Table not available in MSSQL

Function scalar detected, but Function table not detected
Pleaseeeee.....


GBU

What?

I cannot see Table-valued functions in HeidiSQL for MSSQL. Is there a way to do this that I am missing?

What is a "table-valued" function? And where in HeidiSQL exactly do you expect these to see?

Table- valued funcion is a SQL function that is created by the user with a simple SQL statement that returns a SQL select result set. It should appear in the tree on the left along with tables, views, stored procedures.

please give an example.

I have the same problem.

create FUNCTION dbo.test()
RETURNS table
AS
RETURN
SELECT 1 AS RESULT

what is the version of sql server you are using ? (select @@version)

Microsoft SQL Server 2008 (SP2) - 10.0.4064.0 (X64)
Feb 25 2011 13:56:11
Copyright (c) 1988-2008 Microsoft Corporation
Standard Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1) (VM)