The provider Table Editor has no separate tabs for table options and advanced options. All table options can be browsed and changed using the Properties window of Visual Studio 2005.
The following table properties can be set:
Auto IncrementAverage Row Length
Character Set
Checksum for Rows
Collation
Comment
Connection
Data Directory
Delay Key Updates
Engine
Index Directory
Insert Method
Maximum Rows
Minimum Rows
Name
Pack Keys
Password
Row Format
Union
Some of these properties may have arbitrary text values, others accept values from a predefined set. In the latter case set the desired value using an embedded combo box.
The properties Schema and Server are read only.