Get Row Count

Retrieves the number of rows in the table.

Overview

This procedure retrieves the number of rows in the table. You can use it to see if data was loaded correctly, check if a table is empty, or track changes in the amount of data over time.

Input Concepts

Concept
Type
Description
Default
Required

table

table

The table whose row count is to be retrieved.

No default

Yes

Output Concepts

Concept
Description

row count

The number of rows in the table.

Examples

1. Getting the Row Count of a Sample Table

In this example, the table refers to the following table, which can be generated using the create a sample table procedure:

Name
Number
Address
City

john

+ 1 (415) 691 9426

123 east street

San Francisco

joe

+ 1 (415) 691 1234

321 west street

San Jose

jack

+ 1 (415) 691 4595

213 north street

San Francisco

get the table's row count

Last updated

Was this helpful?