Amazon Redshift will no longer support the use of Python UDFs after June 30, 2026.
We will start enforcing it in phases. For more information on the details of Python end of life
and migration options, see the
blog post
DROP TEMPLATE
Drops a template from a database.
Required privileges
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
DROP TEMPLATE [database_name.][schema_name.]template_name;
Parameters
- database_name
-
(Optional) The name of the database in which the template is created. If not specified, the current database is used.
- schema_name
-
(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_name
-
The name of the template to remove. In the following example, the database name is
demo_database, the schema name isdemo_schema, and the template name istest.DROP TEMPLATE demo_database.demo_schema.test;
Examples
The following example drops the template test_template from the current schema:
DROP TEMPLATE test_template;
The following example drops the template test_template from the schema test_schema:
DROP TEMPLATE test_schema.test_template;