Amazon Redshift will no longer support the creation of new Python UDFs starting Patch 198. Existing Python UDFs will continue to function until June 30, 2026. For more information, see the [ blog post ](https://aws.amazon.com/blogs/big-data/amazon-redshift-python-user-defined-functions-will-reach-end-of-support-after-june-30-2026/). 

# DROP TEMPLATE
<a name="r_DROP_TEMPLATE"></a>

Drops a template from a database.

## Required privileges
<a name="r_DROP_TEMPLATE-privileges"></a>

To drop a template, you must have one of the following:
+ Superuser privileges
+ DROP TEMPLATE privilege and USAGE privilege on the schema containing the template

## Syntax
<a name="r_DROP_TEMPLATE-synopsis"></a>

```
DROP TEMPLATE [database_name.][schema_name.]template_name;
```

## Parameters
<a name="r_DROP_TEMPLATE-parameters"></a>

 *database\$1name*   
(Optional) The name of the database in which the template is created. If not specified, the current database is used. 

 *schema\$1name*   
(Optional) The name of the schema in which the template is created. If not specified, the template is searched for in the current search path. 

 *template\$1name*   
The name of the template to remove. In the following example, the database name is `demo_database`, the schema name is `demo_schema`, and the template name is `test`.  

```
DROP TEMPLATE demo_database.demo_schema.test;
```

## Examples
<a name="r_DROP_TEMPLATE-examples"></a>

The following example drops the template test\$1template from the current schema:

```
DROP TEMPLATE test_template;
```

The following example drops the template test\$1template from the schema test\$1schema:

```
DROP TEMPLATE test_schema.test_template;
```