Editing tables

You can edit tables to add new columns, update existing columns, and make changes to the properties of the table.

1. On the Database Explorer tab, select the database.
2. From the list of tables, select the table that you need to edit.
3. From the Table view, click the Actions menu.
4. Select Edit.
5. Edit the details of existing columns.
6. Click Add New Column to add columns to the table.
7. For each column, specify the following details:
   1. Enter the name of the column.
   2. Select the data type of the column from the drop down list.
   3. Click Advanced to add advanced details of each column.
8. Click Advanced tab of the Create Table page.
   1. Select Transactional if you want the table to be a transactional table.
   2. Click Add Location if you want to specify a location for the table.
   3. Select a file format from the drop down list of Add File Format section.
   4. Click Add Row Format to specify details for the rows.
9. Click Properties to add or edit key-value properties of the table.
10. Click Edit to save the changes you made to the table.