RAD Studio (Common)
ContentsIndex
PreviousUpNext
Data Explorer
Provider Types Commands | Individual Provider Commands | Tables Node Commands | Individual Table Commands | View Commands | Stored Procedure Commands
Collapse All

ViewData Explorer 

Adds new connections, modifies; deletes, or renames your connections. You can browse database server-specific schema objects including tables, fields, stored procedure definitions, triggers, and indexes. Additionally, you can drag and drop data from a data source to a project to build your database application quickly. The Data Explorer commands available depend upon the object selected in the tree view. Commands are available for the following nodes:

  • Provider types
  • Provider connections
  • Tables node
  • Individual tables
  • Individual views
  • Individual stored procedures

Provider Types Commands

The following commands are available when you select nodes for providers types, such as DB2 and Interbase:

Item 
Description 
Refresh 
Re-initializes all connections defined for the selected provider.  
Add New Conection 
Adds a new connection to the Data Explorer.  
Migrate Data 
Opens a a tabbed Data Explorer page for data migration in the Code Editor. This data migration page lets you select one or more tables from a source provider connection and a destination connection to which the tables will be migrated. Click Migrate to migrate the tables.  
Individual Provider Commands

The following commands are available when you select nodes for individual provider connections:

Item 
Description 
Refresh 
Re-initializes all connections defined for the selected provider.  
Delete Connection 
Deletes the current connection.  
Modify Connection 
Makes changes to the appropriate values in the editor.  
Close Connection 
Closes the current connection.  
Rename Connection 
Provides a new name to a named connection.  
SQL Window 
Opens the Active Query Builder, a tabbed page for writing and editing SQL statements in the Code Editor. This SQL window can be used to write, edit and execute SQL statements. When you execute the SQL, the results are displayed in the lower part of the page. For details on how to use the Active Query Builder, see http://www.activequerybuilder.com/hs15.html.  
Tables Node Commands

The following commands are available when you select the Tables node for a connection:

Item 
Description 
Refresh 
Re-initializes all connections defined for the selected provider.  
New Table 
Opens a tabbed Data Explorer page for table design in the Code Editor. This Table Design page can be used to specify the data structure for a new table. The Table Design page lets you add and remove columns, and alter column information. The Table Design page lets you change the following column information: Column Name, Data Type, Precision, Scale, and Nullable (that is, whether or not the column can be null). Right-click the page and choose Save Table to add the new table to your database.  
Individual Table Commands

The following commands are available when you select individual tables:

Item 
Description 
Refresh 
Re-initializes all connections defined for the selected provider.  
Retrieve Data From Table 
Opens a tabbed Data Explorer page in the Code Editor, displaying the data from the selected table. The Data Explorer page lets you sort and modify the data, but changes will not be saved back to the database.  
Drop Table 
Removes the selected table and all its data from the database.  
Alter Table 
Opens a tabbed Data Explorer page for table design in the Code Editor. This Table Design page can be used to modify the data structure for an existing table. The Table Design page lets you add and remove columns, and alter column information. The Table Design page lets you change the following column information: Column Name, Data Type, Precision, Scale, and Nullable (that is, whether or not the column can be null). If you make modifications, you are asked to save them when you close the Table Design page.  
Copy Table 
Copies the table structure and data for the selected table.  
Paste Table 
Migrates the table structure and data copied from a given provider to the selected provider. Although you must select a table in the target provider, no data will be overwritten.  
View Commands

The following commands are available when you select individual views:

Item 
Description 
Refresh 
Re-initializes all connections defined for the selected provider.  
Retrieve Data From View 
Opens a tabbed Data Explorer page in the Code Editor, displaying the data from the selected view. The Data Explorer page lets you sort and modify the data, but changes will not be saved back to the database.  
Stored Procedure Commands

The following commands are available when you select individual stored procedures:

Item 
Description 
Locate Implementation 
Navigate to the stored procedure's source code if you have a project with such source code open in the project group. Supported for Blackfish SQL only.  
Refresh 
Re-initializes all connections defined for the selected provider.  
View Parameters 
Opens a tabbed Data Explorer page for viewing and editing stored procedure parameter data in the Code Editor. The stored procedure can also be executed from this page.  
Copyright(C) 2009 Embarcadero Technologies, Inc. All Rights Reserved.
What do you think about this topic? Send feedback!