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.
Note
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 Visual Studio Settings.
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.