CREATE TABLE is ANSI SQL:2011-compliant with extensions.
Global temporary tables are ANSI SQL:2011-compliant.
Other SQL dialects support similar non-ANSI standard statements with names such as the following.
- DECLARE GLOBAL TEMPORARY TABLE
- CREATE TEMP TABLE
Volatile tables are a Teradata extension to the ANSI SQL:2011 standard.
Other SQL dialects support similar non-ANSI standard statements with names such as the following:
- DECLARE GLOBAL TEMPORARY TABLE