New SQLiteTable

.NAME

New-SQLiteTable

.SYNOPSIS

Create new SQLite table based on InputObject.

.PARAMETERS

 -AllText [<SwitchParameter>]
     Sets Column types to TEXT instead of original type (ADO.net truncates decimals this is a way to prevent this)
     
     Required?                    false
     Position?                    named
     Default value                False
     Accept pipeline input?       false
     Accept wildcard characters?  false
     
 
 -InputObject <Object>
     
     Required?                    true
     Position?                    1
     Default value                
     Accept pipeline input?       true (ByValue)
     Accept wildcard characters?  false
     
 
 -Name <String>
     
     Required?                    true
     Position?                    2
     Default value                $InputObject.TableName
     Accept pipeline input?       false
     Accept wildcard characters?  false
     
 
 -Connection <SQLiteConnection>
     
     Required?                    true
     Position?                    3
     Default value                
     Accept pipeline input?       false
     Accept wildcard characters?  false
     
 
 -Unique <Array>
     Sets Column as Unique in database.
     
     Required?                    false
     Position?                    4
     Default value                
     Accept pipeline input?       false
     Accept wildcard characters?  false
     
 
 -WhatIf [<SwitchParameter>]
     
     Required?                    false
     Position?                    named
     Default value                False
     Accept pipeline input?       false
     Accept wildcard characters?  false
     
 
 -PassThru [<SwitchParameter>]
     
     Required?                    false
     Position?                    named
     Default value                False
     Accept pipeline input?       false
     Accept wildcard characters?  false

.INPUTS

<Objects> or <DataTable>

.OUTPUTS

<none>

.NOTES

 Author: Proxx
 Web:    www.Proxx.nl 
 Date:    10-06-2015

.EXAMPLES

 -------------------------- EXAMPLE 1 --------------------------
 
 PS C:\>New-SQLiteTable -conn <SQLiteConnection> -InputObject <Object> -Name <TableName>
 
 
 
 Create Sqlite Table from InputObject with Name: <TableName>
 
 
 
 
 
 -------------------------- EXAMPLE 2 --------------------------
 
 PS C:\>New-SQLiteTable -conn <SQLiteConnection> -InputObject <Object> -Name <TableName> -Unique <Unique column>
 
 
 
 Create Sqlite Table from InputObject with Name: <TableName> with Column <Unique column> as Unique.
 
 
 
 
 
 -------------------------- EXAMPLE 3 --------------------------
 
 PS C:\>New-SQLiteTable -conn <SQLiteConnection> -InputObject <Object> -Name <TableName> -WhatIf
 
 
 
 Shows what Query would have been processed without really sending to database (Debug).
 
 
 
 
 
 -------------------------- EXAMPLE 4 --------------------------
 
 PS C:\>$Object | New-SQLiteTable -conn <SQLiteConnection> -Name <TableName>
 
 
 
 Create Sqlite Table from Pipeline with Name: <TableName>

.RELATED LINKS

http://www.proxx.nl/Wiki/New-SQLiteTable