Syntax - Analytics Database - Teradata Vantage

Database Utilities

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
ft:locale
en-US
ft:lastEdition
2024-05-02
dita:mapPath
ymn1628096214445.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
vkz1472241255652
lifecycle
latest
Product Category
Teradata Vantageā„¢
Not all combinations of acceptable syntax are shown.
SCOPE {
  { class | cylinder | table | vproc | map } [,...] |
  ALL
}
class
CLASS {
  ( { JRNL |
      { PERMANENT | P } |
      { TEMPORARY | TEMP } |
      PSPOOL |
      SPOOL
    } [[,]...]
  ) |
  ALL
}
cylinder
{ CYLINDER | CYL } { ( cylid [[,]...] ) | cylid | ALL }
table
TABLE { ( tid [[,]...] ) | tid | ALL }
vproc
VPROC {
  vproc_number |
  ( { vproc_number | vproc_number TO vproc_number } [[,]...] ) |
  ALL
}
map
MAP { "mapname" | ( "mapname" [[,]...] ) | ALL }