USA
800 691 9120
UK
01225 704844
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.
Add one or more columns to a table if they do not already exist
Adds columns to an existing table, silently skipping any that already exist. Each column can be specified with a full SQL type definition, or just a name to use the default type of nvarchar(255) null. You can also pass a single CSV list of column names in argument 0 to add multiple columns with the default type.
| Parameter | Description |
|---|---|
| cmd | Table name to add columns to |
| Argument 0 | Column definition in the form "ColumnName nvarchar(255) null", or a CSV list of column names; additional columns can be passed in arguments 1, 2, etc. |
AddColumnsToTable "Table name to add columns to", "Column definition in the form "ColumnName nvarchar(255) null", or a CSV list of column names; additional columns can be passed in arguments 1, 2, etc."