Toad for SQL Server 7.4 - Installation Guide

Create and Alter Functions

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

About Functions

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)