The Visual Studio Options window includes settings that you can use to configure the SQL Anywhere Explorer.

To access SQL Anywhere Explorer options

1. From the Visual Studio Tools menu, choose Options.

2. In the left pane of the Options window, expand SQL Anywhere.

3. Click General to configure the SQL Anywhere Explorer general options as required.

   Limit Query Results Sent To Output Window   Specify the number of rows that appear in the Output window. The default value is 500.

   Show System Objects In Server Explorer   Check this option if you want to see system objects in the Microsoft Server Explorer. This is not a SQL Anywhere Explorer option but a Server Explorer option. System objects include those owned by the "dbo" user.

   Sort Objects   Choose to sort objects in the SQL Anywhere Explorer window by object name or by object owner name.

   Generate UI Code When Dropping A Table Or View Onto The Designer   Generate the code for tables or views that you drag and drop onto the Windows forms designer.

   Generate Insert, Update, And Delete Commands For Data Adapters   Generate INSERT, UPDATE, and DELETE commands for the data adapter when you drag and drop a table or view onto a C# or Visual Basic document.

   Generate Table Mappings For Data Adapters   Generate table mappings for the data adapter when you drag and drop a table onto a C# or Visual Basic document.