Chat now with support
Chat with Support

Toad for SQL Server 7.4 - Installation Guide

SQL Server Objects
Edit Permissions on Objects Databases Tables Create and Alter Views Indexes Programmability Create and Alter Synonyms Security Storage Create and Alter Sequences Table, Database and Server Triggers Management Agent

Create and Alter Functions

This topic focuses on information that may be unfamiliar to you. It does not include all step and field descriptions.

To create or alter a function

  1. Select Functions node under the Programmability node in the Object Explorer.
  2. Select one of the following:
    • Click to create a function.
    • Select a function and click to create a function like the selected one.
    • Select a function and click to alter it.
  3. Complete the fields as necessary.  Review the following for additional information:

    General

    Description

    Parameters

    Click to define parameters such as maximum length, precision, etc. for this function.

    Return value

    Description

    Data type

    Select the data type for this function.

    Options

    Description

    Encryption

    Select whether to publish the function during SQL Server replication.

    Schema binding

    Select whether to bind the function to the schema of any objects the function references, such as tables or views. Attempting to alter or drop any object referenced by a schema-bound function fails if this checkbox is selected.

    ANSI Nulls

    Select whether to allow NULLs for functions that use SQL-92 NULL handling.

    Quoted Identifier

    Select whether to identify any strings that use a double quotation mark delimiter as an object identifier.

    On Null Input

    Select whether to accept null values when importing any empty fields from the file.

    User

    Specify the user context to use when executing the function.

 

Related Topics

Create and Alter Assemblies

An assembly consists of .NET assemblies or COM DLLs used by the database or server.

Tip: You can change how objects display in the Object Explorer. For example, you can create custom categories or move objects out of existing categories (such as Programmability and Security) in Tools | Options | Explorer | Objects. See Object Options for more information.

To create or alter an assembly

  1. Select the Assemblies node under the Programmability node in the Object Explorer.
  2. Select one of the following:
    • Click to create an assembly.
    • Select an assembly and click to alter it.
  3. Complete the fields as necessary.

 

Create and Alter XML Schema Collections

Note: This topic focuses on information that may be unfamiliar to you. It does not include all step and field descriptions.

To create or alter an XML schema collection

  1. Select the XML Schema Collection node under the Programmability node in the Object Explorer.
  2. Select one of the following:
    • Click to create an XML schema collection.
    • Select an XML schema collection and click to create an XML schema collection like the selected one.
    • Select an XML schema collection and click to alter it.
  3. Complete the fields as necessary.

  

User-Defined Data Types (UDDTs)

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating