Digital Gridworks Studio Documentation Center Borderland Consulting Inc.

Cart | Search | Site Map

Home > Our Products > Digital Gridworks™ Studio > Documentation > Table Designer

Table of Contents

Managing Connections

Querying Data From The Connection Tree

SQL Editor

Table Designer

Data Migration Services Manager

Database Diagram Editor

Compare Table Definitions

Advanced Data Search

Application Extensions

Extra Information

Developer's Guide

Table Designer

The Table Designer is a feature that is accessed through the connection tree contect menu by selecting Create Table or Design Table. It is also accessed through the context menu when right clicking on a table in a database diagram. The Table Designer is driven off of the connection's database grammar and is therefore limited to the functions that the grammarsupports. Therefore, not all table and column editing functions will be available is a databasegrammar, and one grammar may not produce correct SQL statements for a different database. You canalways view the generated SQL and override it before running the statements if changes need tobe made.

Creating New Tables and Columns

To create a table, select Create Table from the connection tree context menu. The Table Designerform will appear. First, enter the name of the table. Then, use the tool bar items or menu itemsto all and edit columns. You can watch the SQL statements be generated by showing that pane. Nochanges will be committed to the database until you run the SQL statements by clicking on the appropriatetool item or selecting the Run Script menu item.

Editing and Deleting Tables and Columns

In the connection tree, right click on a table and select Design Table from the context menu. The Table Designer should appear. Based upon the connection database grammar's capabilities,you should now be able to create, edit and delete columns from the table as well as rename the table. No changes are committed until you run the genearted SQL script. As a safety precaution, check the SQL statementbefore running it to make sure it complies with the syntax of your database engine.

You can also delete a table by using the connection tree context menu. Right click on the table andselect Drop Table from the context menu.

Viewing Indexes and Keys

The Table Designer lets you view several other pieces of information about the table including anyindexes, primary keys, and imported and exported foreign keys.