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
The dialog boxes and menu commands you see might differ from those described in Help depending on your active settings or edition. To change your settings, choose Import and Export Settings on the Tools menu. 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.