del_="tvf"

<do action_="sql" del_="tvf"> deletes a table-valued function with a given signature from the schema.

Description

del_="tvf" deletes a table-valued function named [FUNCTION] with type signature [SIGNATURE] from a specified schema. If the signature is not specified, del_="tvf" deletes all table-valued functions named [FUNCTION] from the schema.

Syntax

<dynamic>
    <do action_="sql" del_="tvf"
     schema_="[SCHEMA]"
     objname_="[FUNCTION]"
     signature_="[SIGNATURE]"
</dynamic>

Attributes for del_="tvf"

schema_
The schema where the table-valued function is to be deleted.
objname_
The name of the function to be deleted.
signature_
The signature to be deleted from the schema. If a signature is specified, only that signature is deleted and the other function signatures remain. If signature_ is not specified, all table-valued functions with the name [FUNCTION] are deleted from the schema.