Visual Database Tools

  • Article

Feature Only in Enterprise Edition   This feature is supported only in Visual C++ Enterprise Edition. For more information, see .

Visual Database Tools consists of a Query Designer and a Database Designer. With the Query Designer you can graphically create SQL statements to query or update databases. With the Database Designer, you can create, edit, and delete database objects for Microsoft SQL Server 7.0 databases as well as for Oracle version 7 and 8 databases.

For more information, see .

Microsoft Visual C++ Enterprise Edition also provides the Data View pane in the project workspace window. Data View simplifies working with one or more ODBC data sources. You can use Data View to do the following with data sources:

  • Add or remove a data source from a project.

  • Refresh the local version of a data source from the original version.

  • Add a new stored procedure or trigger or edit existing ones.

  • Execute a stored procedure.

  • Drop a stored procedure from a data source.

  • View the column headings and data types of a table or a view.

  • View the properties of a data source.

For more information on Data View and related project workspaces, see .