Modifying Column Properties

To change the properties of a table or view column select the column in the project tree and use the UI controls on the right panel to set new values.

SQL Name
Displays the column name used in the database schema. This value is used to build SQL statements.

Code Name
Specifies the code name that must meet the following requirements:

• Begin with an alphabetic character or an underscore (_).
• Contain only alphabetic characters, decimal digits, and underscores.
• Contain at least one alphabetic character or decimal digit it if begins with
• an underscore.

Display Name
Specifies the display name that is used by WinForm and WebForm controls.

Auto Increment
Specifies whether the corresponding field in the table is auto-increment.

Note: The MS Access and Sybase ASE OLE DB providers do not recognize identity (AutoNumber) columns. Select the Auto Increment option manually for all MS Access and Sybase ASE identity columns.

Read Only
When this option is selected, the generated Update and Insert methods do not update the column value in the database.

Description
Displays the column description. Read only.