Get-SQLiteTables.ps1
|
Function Get-SQLiteTables { <# .Synopsis Gets all sqlite tables in database .DESCRIPTION Gets all sqlite tables in database .EXAMPLE PS C:\> Connect-SQLite -Database .\database.db -Open | Get-SQLiteTables type : table name : TEST tbl_name : TEST rootpage : 2 sql : CREATE TABLE "TEST" (`Name` TEXT , `Length` TEXT ) #> [CmdletBinding()] [OutputType([PSObject])] Param( [Parameter( Mandatory=$true, ValueFromPipeline=$true )] [System.Data.SQLite.SQLiteConnection] $Connection ) Write-output (Read-SQLite -Connection $Connection -Query "SELECT Type, Name, Tbl_Name, Rootpage, SQL FROM sqlite_master WHERE type='table'" -ReturnObject) } |