Databases Reference
In-Depth Information
Once logged on, you will see a page similar to Figure
A-3
, which defaults to the administration summary page
of the database instance, giving you general information about your database instance such as its free space, current
connections, and more. You can also access the design page, a section of the portal that allows you to manage tables,
views, and stored procedures. The administration and design features are explained next.
Figure A-3.
Administration Summary screen
Administration Features
The administration section of the portal allows you to manage your federations, monitor current query performance,
and run T-SQL queries and optionally view their execution plans. Chapter 10 covered federations at length, so this
appendix will focus on the other administration features.
Run T-SQL Statements
Let's first run a T-SQL statement and look at the options available to us. From the administration Summary page,
click the New Query icon on top of the page. This opens up a new query window. You can open as many windows
as needed to run multiple queries as you would in SQL Server Management Studio. Type and execute the following
statement (click the Run icon to execute it):
SELECT * FROM sys.tables
Running this query returns the list of tables currently found in your database. The query window and its result are
shown in Figure
A-4
. The output shows you a grid containing the fields as columns and a row for each table. A scrollbar
shows up on the right if needed. Between the query window and results area, two links are provided: Messages and
Results. The Results link is selected by default (it has a little downward arrow on top of it). Clicking on Messages will
shows you any associated message for the query, including any error messages. As in the SQL Server Management
Studio, if an error is found, the Messages window would be shown by default instead of the Results window.
