Context Options in Database Browser

www.altova.com Print this Topic Previous Page Up One Level Next page

Home >  Data Sources and Targets > Databases and MapForce > Browsing and Querying Databases > Browsing Database Objects >

Context Options in Database Browser

The context menu options available in the Database Browser depend on the object you have selected, for example:

 

Right-clicking the "root" object allows you to Refresh the database.
Right-clicking a folder always presents the same choices: Expand | Siblings | Children and Collapse | Siblings | Children.
Right-clicking a database object reveals the Show in SQL Editor command and the submenu items discussed below.

 

To select multiple database objects, press either Shift + Click or Ctrl + Click.

 

Note:The syntax of the SQL statements may vary depending on the database you are using. The syntax below applies to Microsoft SQL Server 2014.

 

The following options are available under the Show in SQL Editor context menu for the root object:

 

CREATE: Creates a CREATE statement for the selected database root object, for example:
CREATE DATABASE [MYDB]
DROP: Creates a DROP statement for the selected database root object, for example:
DROP DATABASE [MYDB]

 

The following options are available under the Show in SQL Editor context menu for tables and views:

 

SELECT: Creates a SELECT statement that retrieves data from all columns of the source table, for example:
SELECT [DepartmentID], [Name], [GroupName], [ModifiedDate] FROM [MYDB].[HumanResources].[Department]
Name: Returns the name of the table.
Path: Returns the full path of the tables, in the format DataSourceName.DatabaseName.SchemaName.TableName.

 

If you selected multiple tables, the names or paths are printed on separate lines, separated by commas.

 

The following options are available under the Show in SQL Editor context menu for columns:

 

SELECT: Creates a SELECT statement that retrieves data from the  selected column(s) of the parent table, for example:
SELECT [DepartmentID] FROM [MYDB].[HumanResources].[Department]
Name: Returns the name of the selected column.
Path: Returns the full path of the column, in the format DataSourceName.DatabaseName.SchemaName.TableName.ColumnName.

 

If you selected multiple columns, the names or paths are printed on separate lines, separated by commas.

 

The following options are available under the Show in SQL Editor context menu for constraints:

 

Name: Returns the name of the selected constraint.
Path: Returns the full path of the constraint, in the format DataSourceName.DatabaseName.SchemaName.TableName.ConstraintName.

 

If you selected multiple constraints, the names or paths are printed on separate lines, separated by commas.

 

The following options are available under the Show in SQL Editor context menu for indexes:

 

Name: Returns the name of the selected index.
Path: Returns the full path of the index, in the format DataSourceName.DatabaseName.SchemaName.TableName.IndexName.

 

If you selected multiple indexes, the names or paths are printed on separate lines, separated by commas.

 

If the database has support for XML Schemas, the following options are available for every schema displayed under the "XML Schemas" folder:

 

View in XMLSpy: Opens the database schema in XMLSpy, provided that the latter is installed.
Manage XML Schemas: Opens a dialog box where you can add new or drop existing database XML schemas.

© 2019 Altova GmbH