Export (0) Print
Expand All

SqlFunctionAttribute.TableDefinition Property

A string that represents the table definition of the results, if the method is used as a table-valued function (TVF).

Namespace:  Microsoft.SqlServer.Server
Assembly:  System.Data (in System.Data.dll)

public string TableDefinition { get; set; }

Property Value

Type: System.String
A String value representing the table definition of the results.

This attribute is used only by Microsoft Visual Studio to automatically register the specified method as a TVF. It is not used by SQL Server.

The following example specifies that the user-defined function is referenced using the name sp_tableFunc. The TableDefinition property has the value letter nchar(1).

public partial class UserDefinedFunctions
{
    [SqlFunction(Name="sp_tableFunc", TableDefinition="letter nchar(1)")]
    public static IEnumerable SampleTableFunction(SqlString s)
    {
        //... 
        return new ArrayList(new char[3] {'a', 'b', 'c'});
    }
}

.NET Framework

Supported in: 4.6, 4.5, 4, 3.5, 3.0, 2.0

.NET Framework Client Profile

Supported in: 4, 3.5 SP1
Show:
© 2015 Microsoft