How to rename a table in Teradata?
Teradata Rename Table We can rename the existing Teradata table using RENAME TABLE statement.We should have DROP privileges on the
Continue readingCategory: Teradata
Conditional execution of SQL statements using activity count in Teradata BTEQ
ACTIVITY_COUNT in Teradata Activity count is a variable that returns the number of rows affected by the SQL statement in
Continue readingHow to split the string based on delimiter in Teradata
STRTOK function in Teradata STRTOK function is used to split the string into tokens based on the specified delimiter. It
Continue readingPerformance tuning using Collect Statistics in Teradata table with examples
Collect Statistics in Teradata Collect statistics statement is collects the demographic data for one or more columns ,hash indexes ,
Continue readingHow to name the Primary indexes in Teraata table with examples
Primary Index in Teradata While we create the table in Teradata, we can specify the Primary index(PI) or Unique primary
Continue readingHow to extract the substring from the value of a column in Teradata?
Substring() function in Teradata Substring function is used to extract a portion of a string from the value of a
Continue readingHow to find duplicates in a Teradata table
We can use GROUP BY clause to find how many times the value is duplicated in a table. Group by
Continue readingHow to find number of AMPs used in the Teradata Database system?
AMPs (Access Module Processor) in Teradata Access Module Processor(AMP) is a virtual processor(vproc) that used to stores and retrieve the
Continue readingHow to find all the tables created by specific user in Teradata?
Meta data tables in DBC database: Teradata meta data tables are stored in DBC database.The table level information present in
Continue readingAdd new column to a table using alter table statement in Teradata
Alter table in Teradata: Alter table statement is used to add new columns to the existing table in Teradata. It
Continue reading