QueryODBC > Schema Tab

Fields

Insert Type (drop list)

Select the type of data to insert at the current insertion point in the command text field of the command tab. See insert button below for details.

Schema Tree

The schema tree displays detailed information about the tables, stored procedures and views in your database. The level of detailed information displayed will vary by database provider.

Tables

Click on the "Tables" folder to view a detailed list of the system and user tables contained in the database. Expand the "Tables" folder to expose the "System Tables" and "User Tables" folders. Click on the "System Tables" folder to view a detailed list of the system tables contained in the database. Click on the "User Tables" folder to view a detailed list of the user tables contained in the database. Expand the "System Tables" or "User Tables" folders to expose the tables contained in each folder. Click on a user or system table to view detailed information about the table's columns. Expand a user table to expose the "Primary Key," "Foreign Keys (within)," "Foreign Keys (without)," "Indexes," and "Constraints" nodes. Click the "Primary Key" node to view details about the columns that comprise the primary key of the parent table. Click the "Foreign Keys (within)" node to view details about the columns contained within the parent table that are foreign keys to other tables. Click the "Foreign Keys (without)" node to view details about the columns in tables other than the parent table that are foreign keys to columns contained in the parent table. Click the "Indexes" node to view details about indexes contained in the parent table. Click on the "Constraints" node to view details about the constraints contained in the parent table.

Stored Procedures

Click on the "Stored Procedures" folder to view a detailed list of the stored procedures contained in the database. Expand the "Stored Procedures" folder to expose the stored procedures contained in the folder. Click on a stored procedure to view detailed information about the procedure's parameters.

Views

Click on the "Views" folder to view a detailed list of the system and user views contained in the database. Expand the "Views" folder to expose the "System Views" and "User Views" folders. Click on the "System Views" folder to view a detailed list of the system views contained in the database. Click on the "User Views" folder to view a detailed list of the user views contained in the database. Expand the "System Views" or "User Views" folders to expose the views contained in each folder. Click on a user or system view to view detailed information about the view's columns.

Data Types

Click on the "Data Types" folder to view a detailed list of the data types supported by your database provider.

Schema Grid

Displays detailed information about the currently selected item in the schema tree.

Data Type, Column Flags, Procedure Type and Parameter Type Columns

To view the description(s) related to the "DATA_TYPE," "COLUMN_FLAGS," "PROCEDURE_TYPE," or "PARAMETER_TYPE" values displayed in the schema grid, place your mouse over the cell containing the value (the descriptions will display as a tool tip), or select the cell containing the value (the descriptions will display in the status bar).

Auto-Size Columns

To auto-size a column in the grid, double-click on the column heading. To auto-size all columns in the grid, double-click on the row number column heading. Use schema tab options to specify whether column headings should be included or excluded from the column auto-size calculation.

Date/Time Format

Date/Time formatting is controlled by the "regional settings" in the Windows Control Panel. To change date/time formatting, select "settings" then "control panel" from your windows start menu, then select "regional settings." See Windows help for details.

Buttons

Refresh

Reload the schema tree. If schema changes were made to your database during the current QueryODBC session, you must refresh the schema tree to see the updated schema.

Insert

Insert the selected item(s) in the schema tree or schema grid, at the current insertion point in the command text field of the command tab. Use the Insert Type droplist to specify the type of data to be inserted.

Tables/Columns

To insert a single table name or a comma delimited list of table names, click the "Tables," "System Tables," or "User Tables" folder in the schema tree, then select the table(s) to be inserted in the schema grid.

To insert a single table name, select the table in the schema tree, then select "Table Name" from the Insert Type drop list.

To insert a single column name or a comma delimited list of column names, select a table in the schema tree, select "Column Name" from the Insert Type droplist, then select the column(s) to be inserted in the schema grid.

To insert a single table and column name (in table.column notation) or a comma delimited list of table and column names, select a table in the schema tree, select "Table.Column Name" from the Insert Type drop list, then select the column(s) to be inserted in the schema grid.

To insert an SQL command that will retrieve all of the data contained in a table, select a table in the schema tree, then select "Get Data (SELECT * FROM table)" from the Insert Type drop list.

Stored Procedures/Parameters

To insert a single procedure name or a comma delimited list of procedure names, click the "Procedures" folder in the schema tree, then select the procedure(s) to be inserted in the schema grid.

To insert an EXEC command for a single procedure (formatted as "EXEC ProcedureName"), select the procedure in the schema tree, then select "Procedure Name" from the Insert Type drop list.

To insert a single parameter name (formatted as "ParameterName =") or a comma delimited list of parameter names, select a procedure in the schema tree, select "Parameter Name" from the Insert Type drop list, then select the parameter(s) to be inserted in the schema grid. Note, "return" and "output" parameters are excluded from insert. If you desire to insert "return" or "output" parameters, use copy/paste.

To insert a complete EXEC command, including a parameter list, for a single procedure (formatted as "EXEC ProcedureName ParameterName = , ParameterName =…"), select the procedure in the schema tree, select "Procedure and Parameter Name" from the Insert Type droplist, then select the parameter(s) to be included in the command in the schema grid. Note, "return" and "output" parameters are excluded from insert. If you desire to insert "return" or "output" parameters, use copy/paste.

Views/Columns

To insert a single view name or a comma delimited list of view names, click the "Views," "System Views," or "User Views" folder in the schema tree, then select the view(s) to be inserted in the schema grid.

To insert a single view name, select the view in the schema tree, then select "View Name" from the Insert Type droplist.

To insert a single column name or a comma delimited list of column names, select a view in the schema tree, select "Column Name" from the Insert Type droplist, then select the column(s) to be inserted in the schema grid.

To insert a single view and column name (in view.column notation) or a comma delimited list of view and column names, select a view in the schema tree, select "View.Column Name" from the Insert Type droplist, then select the column(s) to be inserted in the schema grid.

To insert an SQL command that will retrieve all of the data contained in a view, select a view in the schema tree, then select "Get Data (SELECT * FROM view)" from the Insert Type droplist.

Tip: You can also insert table and column names using the insert table/column window.

Tip: As an alternative to the insert button, you can copy data from the schema grid using edit/copy and then paste the data into the command tab. However, the insert button will generally insert data in a format that is better suited for use in SQL commands.

Menu / Toolbar

File/Save As

Save the data in the schema grid to a file. You can save schema data in HTML (.HTM) or text (.TXT) format by selecting the desired format from the save as type list in the save as dialog. Use schema tab options to specify the HTML template file that will be used to format schema data saved as an HTML document. Use schema tab options to specify the delimiter for schema data saved as a text file.

Edit/Copy

Copy the text in the currently selected cells to the clipboard. If you select an entire column, the column heading is also copied to the clipboard. Use schema tab options to specify the copy delimiter.

Edit/Find/Replace

Find text in the currently selected cells in the schema grid. The find drop list displays all previous search text for the current session. Trim replaced text is not applicable on this tab.

Edit/Font

Change the font, font size, font bold, and font italic attributes of the text in the schema grid. Note, the selected font is also applied to the command text field, the statistics text field and the results grid.

Process/Sort

Sort all rows in the results grid by the currently selected column(s). If more than one column is selected, the leftmost selected column is used as the first sort key. Additional selected columns are used as the second and greater sort keys (i.e. 2nd selected column from the left is used as second sort key, 3rd selected column from the left is used as the third sort key, etc.).

Process/Backup Data

Create a copy of the data contained in the current database. The data is stored in a backup file set. You will be prompted to select the directory where the backup file set is to be stored. Backup processing will overwrite duplicate files in the selected directory.

Tip: You can use Process/Backup Data and Process/Restore Data to move your data from one database provider to another (i.e. MS Access to Oracle, Oracle to MS SQL Server, etc.).

Process/Insert Data

Load the data in an ADO recordset file into the table or view selected in the schema tree. This option is only enabled when you select a destination table or view in the schema tree. Use File/Save As to create ADO record set files.

Tip: You can use File/Save As and Process/Insert Data to move selected data from one table, database or database provider (i.e. MS Access to Oracle, Oracle to MS SQL Server, etc.) to another.

Process/Restore Data

Copy the data contained in a backup file set into the current database. The backup file set is created using the Process/Backup Data menu option (see above). You will be prompted to select the directory where the backup file set is located. All existing data in the restored tables is deleted prior to restoring data from the backup file set.

The Restore Table Order window allows you to select the tables to be restored, and specify the order in which they are restored.

Table order is important due to foreign key constraints. If your database provider supports foreign key functionality, QueryODBC will resolve the foreign key relationships and automatically order the tables to ensure that restore processing does not violate any foreign key constraints. If your database provider does not support foreign key functionality, you must manually order the tables. In the Restore Table Order window, tables that do not contain any foreign keys must be listed first, followed by tables that contain foreign keys. A table that contains foreign keys must be ordered after the table(s) that it's foreign keys reference. If you remove a table from the list using the Remove button, the table will not be restored.

Tip: If any of your tables contain "auto number" fields, you must temporarily disable the "auto number" feature prior to restoring data.

Process/Options

Display schema tab options.