Editing Column Properties
When you select a table or virtual table from the left pane of the Design View, the main pane displays its properties as well as the properties of the columns that it contains. You can edit column properties to change the way that the columns are handled in ODBC and JDBC applications.
Note:
Some properties are read-only and cannot be edited. This includes properties such as Column #, Primary Key Column, and Foreign Key Column. For more information, see Column Properties.
The center area of the main pane displays column properties. The header contains the property names, and each row contains the property values for one column.
To locate the row for a specific column, in the Search Column Names field, type the column name, and then click 
or 
to browse through the search results. The Schema Editor highlights any rows where the column name contains the search term.
The exact column properties that are available in the main pane differ depending on the specific NoSQL data store that you are working with, but typically include the following:
SQL Name: The column name that is used in SQL operations.Source Name: The column name that is used in the NoSQL data store.SQL Type: The SQL data type that the column is mapped to for SQL operations.Source Type: The NoSQL data type that the column is mapped to in the NoSQL data store.
For more information about specific column properties, see Column Properties.
To edit column properties:
- In the Design View, in the left pane, select the table containing the properties that you want to edit.
- In the main pane, click the cell containing the value that you want to edit and then do one of the following:
- If the cell is an editable field, then type your new value and press ENTER.
- If the cell is a drop-down list, then select a value from the list.