search

jdhitsolutions / MySQLite

A small set of PowerShell commands for working with SQLite database files.
MIT License
41 stars 4 forks source link

Need a way to get table details #7

Closed jdhitsolutions closed 5 years ago

jdhitsolutions commented 5 years ago

Need a command or parameter with Get-MySqliteTable to show details. Someone might not remember all the table property names.

iq .\foo3.db -Query "Select * from sqlite_master"

type     : table
name     : Metadata
tbl_name : Metadata
rootpage : 2
sql      : CREATE TABLE Metadata (Author TEXT,Created TEXT,Computername TEXT,Comment TEXT)

type     : table
name     : data
tbl_name : data
rootpage : 3
sql      : CREATE TABLE data (Name text PRIMARY KEY,Date text,User text,size int)
jdhitsolutions commented 5 years ago

Or this:

PS Drop:\work> iq .\foo3.db -Query "PRAGMA table_info(jeff)" | Select Name,Type

name     type
----     ----
Size     INT
Name     TEXT
Category TEXT
jdhitsolutions commented 5 years ago

added in 0.4.0