Column Options, Table and Database Designers, Database Tools, Options Dialog Box

Use this page of the Options dialog box to change the defaults for columns in Table Designer. You can access the Options dialog box from the Tools menu.


Your computer might show different names or locations for some of the Visual Studio user interface elements in the following instructions. The Visual Studio edition that you have and the settings that you use determine these elements. For more information, see Customizing Development Settings in Visual Studio.

Default column type

Provides a drop-down list of data types available to use as the default when a column is created. You can change the data type in the Column Properties window in the Table Designer.

Default allow null

Checked, this specifies that the default will not only be of the data type listed above, but that it also allows null values. Unchecked it specifies that the default column does not allow null values.

Column Type

Lists the data types that have a length property.

Default Length

Provides text boxes where you can specify the default for each data type listed. This length can be changed in the Column Properties window of the Table Designer.

Community Additions