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 a database.
  2. From the list of tables, select the table that you want to edit.
  3. From the Table view, click the Actions menu.
  4. Click 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 more details for each column.
  8. Click the Advanced tab on the Create Table page to specify the following additional options:
    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.