SqlFunctionAttribute.TableDefinition Property
Important
Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.
A string that represents the table definition of the results, if the method is used as a table-valued function (TVF).
public:
property System::String ^ TableDefinition { System::String ^ get(); void set(System::String ^ value); };public string TableDefinition { get; set; }member this.TableDefinition : string with get, setPublic Property TableDefinition As StringA String value representing the table definition of the results.
// using Microsoft.Data.SqlClient.Server;
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' });
}
}
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).