Linker IT Software
Order Home
menubar-top-links menubar-top-rechts

SQL*XL: Database to Excel bridge

Related LIT software: litLIB: Excel power functions pack encOffice: Protect your Excel file easy and safe

Home Products SQL*XL Help Dialogs SQL Editor

Buy now

Download now

SQL*XL online help
 

SQL*XL: SQL editor: Database Objects section

Database Objects section (SQL editor)

SQL*XL
home


The SQL editor will show the database objects in this section. Open the schema of interest and within that the tables or views list to see the database objects you can use. Each item in the tree has different behavior. The action menu presented in the menu bar but also when you right click the item shows the actions you can perform on that object. You can drag and drop items into the SQL text area. You can also right click an item and select an action. You can generate most used SQL statements from this menu.

Typically the database objects list shows the following details:

Schemas This is the container where all your and other users database objects reside.
-Schema Within schemas you find the list of schemas / users. Some database types can only have one schema so the items will be titled "Current Schema"
From the actions menu can can describe all tables and views.
--Tables The tables list shows all tables found in the database.
Available actions:
-Select: create a select * statement for all tables in the list
-Create: shows the table creation wizard
-Count rows in all tables
-Describe all tables
-Sample rows from all tables
--Views The tables list shows all tables found in the database.
Available actions:
-Select: create a select * statement for all tables in the list
-Count rows in all views
-Describe all views
-Sample rows from all views



See also:

SQL*XL ribbon in Excel