SHOW TABLE and Language Support Mode of a System - Analytics Database - Teradata Vantage

SQL Data Definition Language Detailed Topics

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-12-13
dita:mapPath
vuk1628111288877.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
jbg1472252759029
lifecycle
latest
Product Category
Teradata Vantage™

You cannot submit a SHOW TABLE request against a dictionary table to determine the language support mode for your system because Vantage always returns the value Unicode as the response to such a request.

Instead, you must submit the following SELECT request to determine the language support mode used by your system.

SELECT infodata
FROM DBC.dbcinfoV
WHERE infokey='language support mode';
IF your system uses this language support mode … THEN the InfoKey value the system returns is …
standard Standard
Japanese Japanese