TD_FillRowID Function | FillRowID | Teradata Vantage - TD_FillRowID - Analytics Database

Database Analytic Functions

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2024-10-04
dita:mapPath
gjn1627595495337.ditamap
dita:ditavalPath
ayr1485454803741.ditaval
dita:id
jmh1512506877710
Product Category
Teradata Vantageā„¢

TD_FillRowID adds a column of unique row identifiers to an input table.

This function may not return the same RowIds if the function is run multiple times.

Row IDs are used in tables to uniquely identify each row within the table. They serve to ensure that each row in the table has a unique identifier that can be easily retrieved or updated.

Row IDs are typically assigned automatically by the database management system (DBMS) when a new row is added to the table, although they can also be assigned manually by a user.

Row IDs are useful for a variety of reasons, including:
  • Ensuring data integrity: With a unique identifier for each row, it is easier to ensure that there are no duplicate rows in the table, which can cause data inconsistencies and errors.
  • Enabling efficient searches: When searching for specific rows within a table, using the row ID as a search criterion can be faster and more efficient than searching based on other attributes.
  • Supporting table relationships: In relational databases, row IDs are often used as foreign keys in related tables, which allows for linking between different tables in the database.

Overall, row IDs are a fundamental component of table design and are essential for the proper functioning of many database applications.