Use the Name and Language page of the New User-Defined
Function
wizard to specify the basic options for creating a user-defined function.
- Name
- Type a name for the user-defined function. The name can be qualified
with
the schema name, and can contain alphanumeric characters but must
start with
an alphabetic character. You can delimit the user-defined function
name with
quotation marks to preserve lowercase characters or spaces.
- Language
- Shows that the language for
the user-defined function is SQL.
- Replace
existing
- Available only when creating a UDF for XML: Select
to drop a user-defined
function from the database before the new one is created if it has
the same
name and signature as the one specified in the name field.