Top "Teradata" questions

Teradata is a Relational Database Management System (RDBMS), capable of supporting many concurrent users from various client platforms.

Using COLLECT STATISTICS in Teradata

In Teradata I can use a statement like ... collect statistics on my_table column(col1) This will gather stats on …

sql database query-optimization teradata
How to delete rows in a Teradata table that are not in another table?

What makes my situation tricky is that I don't have a single column key, with a simple list of primary …

sql teradata
sql: like any vs like all

I can't figure out why sometimes LIKE requires ANY and other times it requires ALL, and it's making me crazy. …

sql teradata
Retrieving column and other metadata information in Teradata

I have a half dozen views in SQL Server that I need to replicate in Teradata, but I haven't been …

sql teradata
Split String Teradata SQL

I'm looking to split a string in Teradata. The table might look something like this. column1 hello:goodbye:afternoon I'm …

sql database substring teradata
Teradata update join syntax

I've tried a few examples I've seen on the internet, but I can't seem to figure them out. This is …

sql join teradata
Teradata - run a file/script at Unix Linux command prompt

I have the client/TTU installed on Unix box for Teradata. If I do the following, it works. Where "..." is …

unix client teradata automated-deploy
Teradata: Is there a way to generate DDL from a view or select statement?

I am using a global application user account to access database A. This user account does not have permissions to …

teradata
Show column name and data type in Teradata?

Is there a way to get column name and data type in a Teradata SQL Assistant 15.0view? In Oracle 11g …

sql oracle oracle11g teradata
How to find all tables / views with a column name that matches a particular pattern

How do I find all tables or views that have a column name that matches a pattern. The pattern is …

teradata