...
Query of empty data table.
Remarks
This method is used to create a empty data table for importing data on target table without querying the database.
Query parameter is used to specify target table and schema.
Example
...
Code Block | ||
---|---|---|
| ||
var myTable = $Database.Empty({
TargetSchema : 'HR',
TargetTable : 'Groups'
});
myTable.Add({Id : 'A', Name : 'Admin'});
myTable.Add({Id : 'U', Name : 'User'});
myTable.Save(); |
...
Get Empty Data Table
Code Block | ||
---|---|---|
| ||
var myTable = $Database.Empty({ TargetSchema : 'HR', TargetTable : 'Groups' }); myTable.Add({Id : 'A', Name : 'Admin'}); myTable.Add({Id : 'U', Name : 'User'}); myTable.Save(); |