LegacyData

3.2.0

Experimental/Research-RowCountOfAllTables.ps1

1
2
3
4
5
6
7
8
9
10
11
12
13

                                <# 

.SYNOPSIS

Does a row count of all tables in a folder.

#>

param (

    $Path 

)

Get-ChildItem -path $Path -Filter *.dbf | ForEach-Object{

        Invoke-foxproQuery -DataSource $Path -Query "SELECT '$($_.Basename)' AS TableName, COUNT(*) AS COUNT_OfRows FROM $($_.Basename)" 

    }