Adding and Deleting Columns
Note:
This feature is not currently available for DocumentDB.
In some cases, due to the configuration settings used during the sampling process, the connector might generate a schema definition that does not contain all the desired table columns. To correct the schema definition, you can use the Schema Editor to add or delete columns. However, you can only delete columns that have the User Generated Column property set to true.
To add a column:
- In the Design View, in the left pane, select the table that you want to add a column to.
- In the main pane, click Add Column. A row representing the new column is added to the main pane.
- Define properties for the new column. For detailed instructions, see Editing Column Properties.
To delete a column:
- In the Design View, in the left pane, select the table that you want to delete a column from.
- In the main pane, specify the column that you want to delete by selecting the corresponding check box in the Selected column.
- Click Delete Column.
The selected column is deleted from the schema definition.