DEALLOCATE

Applies to: ❌ Data Cloud SQL ✅ Tableau Hyper API

Deallocate a prepared statement.

Syntax 

 
DEALLOCATE [PREPARE] { <name> | ALL }

Description 

DEALLOCATE is used to deallocate a previously prepared SQL statement. If you do not explicitly deallocate a prepared statement, it is deallocated when the session ends.

For more information on prepared statements, see PREPARE.

Parameters 
PREPARE

This optional key word is ignored and has no semantical meaning.

<name>

The name of the prepared statement to deallocate.

ALL

Deallocate all prepared statements.

Compatibility 

The SQL standard includes a DEALLOCATE statement, but it is only for use in embedded SQL.

Clouds with binary code floating aboveCloud with binary code floating above

No Results

Search Tips:

  • Please consider misspellings
  • Try different search keywords
Data Cloud SQL Reference
Data Cloud SQL and Tableau Hyper API
Data Cloud SQL Syntax
Syntax
SELECT
WITH Clause
SELECT List
FROM Clause
GROUP BY Clause
WINDOW Clause
UNION, INTERSECT, and EXCEPT Operators
ORDER BY Clause
LIMIT, FETCH, and OFFSET Clauses
VALUES
Data Types
Boolean Type
String Types
Numeric Types
Date/Time Types
Binary Type
Array Type
Scalar Functions
Type Conversions
Comparison Operators
Subquery Comparisons
Logical Operators
Conditional Expressions
Mathematical Functions and Operators
String Functions and Operators
String Pattern Matching
Data Type Formatting Functions
Array Functions
Date/Time Functions and Operators
Aggregate Functions
Window Functions
Set Returning Functions
External File Support
Reading External Data in SQL
External Formats and Options
External Locations
SQL Commands for Tableau Hyper API
INSERT
UPDATE
DELETE
TRUNCATE
COPY FROM
COPY TO
CREATE DATABASE
CREATE SCHEMA
CREATE TABLE
CREATE TABLE AS
CREATE EXTERNAL TABLE
ALTER SCHEMA
ALTER TABLE
DROP TABLE
DROP SCHEMA
DROP DATABASE
EXPLAIN
PREPARE
EXECUTE
DEALLOCATE
Data Cloud REST API Reference