Empty¶

Returns an empty DataTable for importing data on target table.

1

$Database.Empty(query: Query):DataTable

Parameters¶

Query query
    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.

Get Empty Data Table¶

1
2
3
4
5
6
7

var myTable = $Database.Empty({
    TargetSchema : 'HR',
    TargetTable : 'Groups'
});
myTable.Add({Id : 'A', Name : 'Admin'});
myTable.Add({Id : 'U', Name : 'User'});
myTable.Save();

See Also¶

• DataTable