This task can help you to add a new column to an existing table.
CREATE TABLE [NewTable] (CountField int, DateField datetime)
ALTER TABLE [NewTable] ADD COLUMN NewField = {NULL}
SAVE
Note: The script will fail if the 'Query' property is left empty.
Examples of Query vaules:
- NULL. Insert NULL if your new column should remain empty.
- 1000. Insert a fixed value when column is created. Data type: Integer.
- 'Unknown'. Insert a fixed text when column is created. Data type: String.
Comments
Please sign in to leave a comment.