Database Counts

<< Click to Display Table of Contents >>

Navigation:  View Indexes > Examples Usage >

Database Counts

There are multiple columns that give count information. All are calculated in the same way. Below is an example of Item Count.

 

 

columns that have counts are:

 

Item Count

Row Count

 

 

 

Item Count

Item Count gives total counts for tables, views, indexes and columns. The count varies on the level in the tree.

 

Level

Level

Description

1

Database

Count of tables and views in the database

2

Table/View Header

Count of tables in the database

3

Table/View

Count of columns in the table/view.

 

 

Example Usage

 

Sort by the item count descending to show tables with the largest number of columns.

 

Example

clip0004