Share via

Function Properties

  • Article

These properties appear in the Properties window when you select a function in Server Explorer. Unless noted, these properties apply only to SQL Server 2005 and SQL Server 2008.

Note

The properties in this topic are ordered by category rather than alphabet.

Note

Your computer might show different names or locations for some of the Visual Studio user interface elements in the following instructions. The Visual Studio edition that you have and the settings that you use determine these elements. For more information, see Visual Studio Settings.

  • Identity Category
    Expands to show the Name property.

  • Name
    Shows the name of the selected function.

  • Misc Category
    Expands to show properties for Assembly Name, Function Type, and In Encrypted.

  • Assembly Name
    Shows the name of the assembly in which the function is used.

  • Function Type
    Shows the return type of this function: Scalar-valued, Table-valued, or Inline.

  • Is Encrypted
    Shows whether the user-defined function was created with an optional encryption parameter.

See Also

Other Resources

Properties in Visual Database Tools

Working with Stored Procedures and User-Defined Functions