IBM PureData System for Analytics, Version 7.1

Palabras reservadas comunes de SQL

El lenguaje SQL está compuesto de palabras reservadas, es decir, palabras especiales que ejecutan operaciones SQL.

Restricción: No utilice estas palabras reservadas cuando ponga nombre a bases de datos, tablas, columnas o cualquier objeto de la base de datos.
Ka tabla siguiente contiene una lista de palabras reservadas comunes.
Tabla 1. Palabras reservadas
ABORT DEC LEADING RESET
ADMIN DECIMAL LEFT REUSE
AGGREGATE DECODE LIKE RIGHT
ALIGN DEFAULT LIMIT ROWS
ALL DEFERRABLE LISTEN ROWSETLIMIT
ALLOCATE DESC LOAD RULE
ANALIZAR DISTINCT LOCAL SEARCH
ANALYZE DISTRIBUTE LOCK SELECT
AND DO MATERIALIZED SEQUENCE
ANY ELSE MINUS SESSION_USER
AS END MOVE SETOF
ASC EXCEPT NATURAL SHOW
BETWEEN EXCLUDE NCHAR SOME
BINARY EXISTS NEW SUBSTRING
BIT EXPLAIN NOT SYSTEM
BOTH EXPRESS NONULL TABLE
CASE EXTEND NULL THEN
CAST EXTERNAL NULLIF TIES
CHAR EXTRACT NULLS TIME
CHARACTER FALSE NUMERIC TIMESTAMP
CHECK FIRST NVL TO
CLUSTER FLOAT NVL2 TRAILING
COALESCE FOLLOWING OFF TRANSACTION
COLLATE FOR OFFSET TRIGGER
COLLATION FOREIGN OLD TRIM
COLUMN FROM ON TRUE
CONSTRAINT FULL ONLINE UNBOUNDED
COPY FUNCTION ONLY UNION
CROSS GENSTATS OR UNIQUE
CURRENT GLOBAL ORDER USER
CURRENT_CATALOG GROUP OTHERS USING
CURRENT_DATE HAVING OUT VACÍO
CURRENT_DB IDENTIFIER_CASE OUTER VARCHAR
CURRENT_SCHEMA ILIKE OVER VERBOSE
CURRENT_SID IN OVERLAPS VERSION
CURRENT_TIME INDEX PARTITION VIEW
CURRENT_TIMESTAMP INITIALLY POSITION WHEN
CURRENT_USER INNER PRECEDING WHERE
CURRENT_USERID INOUT PRECISION WITH
CURRENT_USEROID INTERSECT PRESERVE WRITE
DEALLOCATE INTERVAL PRIMARY RESET
  INTO   REUSE
Además, IBM® Netezza SQL considera los siguientes atributos de sistema palabras reservadas:
  • CTID
  • OID
  • XMIN
  • CMIN
  • XMAX
  • CMAX
  • TABLEOID
  • ROWID
  • DATASLICEID
  • CREATEXID
  • DELETEXID
Tema principal: Palabras clave y palabras reservadas de SQL

Feedback | Copyright IBM Corporation 2014 | Last updated: 2014-02-28