We use cookies on our website to analyze website usage and to help secure the website against misuse. Advertising and functional cookies are not used in our site or our web application products.
By clicking “Accept Essential Cookies Only”, you consent to us placing these cookies.
Create a copy of a database table, optionally seeded with rows
Creates a new temp table with the same structure as the source table. If a WHERE clause is supplied the matching rows are copied; if blank the new table is created empty. The destination table name must include a database qualifier (i.e. must reference the xAssets temp database).
| Parameter | Description |
|---|---|
| cmd | destination table name (must contain a dot, e.g. $tempdb$MyTable) |
| Argument 0 | source table name to copy structure (and optionally data) from |
| Argument 1 | WHERE clause to select rows to copy (leave blank to create an empty table) |
CreateTableCopy "destination table name (must contain a dot, e.g. $tempdb$MyTable)", "source table name to copy structure (and optionally data) from", "WHERE clause to select rows to copy (leave blank to create an empty table)"