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.