Rows and Columns - Teradata Vantage - Analytics Database

Database Introduction

Deployment
VantageCloud
VantageCore
Edition
VMware
Enterprise
IntelliFlex
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
ft:locale
en-US
ft:lastEdition
2023-09-27
dita:mapPath
gtm1628096154303.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
dsm1472253642401
lifecycle
latest
Product Category
Teradata Vantageā„¢

A column contains the same kind of information. For example, a table that has information about employees has a column for last name and only employee last names belong in that column.

A row is one instance of all the columns in a table. For example, each row in the employee table contains the first name and the last name for one employee. The columns in a table represent entities, relationships, or attributes.

An entity is a person, place, or thing about which the table contains information. The employee table contains information about the employee entity. Each table holds only one kind of row. The relational model requires that each row in a table be uniquely identified. To accomplish this, you define a uniqueness constraint to identify each row in the table. For more information about primary keys, see Comparison of Primary Indexes and Primary Keys.