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
- Select Functions node under the Programmability node in the Object Explorer.
- 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.
- Click
-
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.
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
- Select the Assemblies node under the Programmability node in the Object Explorer.
- Select one of the following:
- Click
to create an assembly.
- Select an assembly and click
to alter it.
- Click
- 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
- Select the XML Schema Collection node under the Programmability node in the Object Explorer.
- 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.
- Click
- Complete the fields as necessary.