Filter
Top Products
CHAPTER 3 Managing the Database
DataWindow Designer User’s Guide 81
2 In the Object Details view, select or deselect columns as needed.
3 Right-click on the Object Details view and select Save Changes from the
pop-up menu.
Any changes you made in the view are immediately saved to the table
definition.
Dropping an index
Dropping an index removes it from the database.
❖ To drop an index from a table:
1 In the Database painter workspace, display the pop-up menu for the index
you want to drop.
2 Select Drop Index and click Yes.
Working with database views
A database view gives a different (and usually limited) perspective of the data
in one or more tables. Although you see existing database views listed in the
Objects view, a database view does not physically exist in the database as a
table does. Each time you select a database view and use the view’s data,
DataWindow Designer executes a SQL
SELECT statement to retrieve the data
and creates the database view.
For more information about using database views, see your DBMS
documentation.
Using database views
in DataWindow
Designer
You can define and manipulate database views in DataWindow Designer.
Typically you use database views for the following reasons:
• To give names to frequently executed
SELECT statements.
• To limit access to data in a table. For example, you can create a database
view of all the columns in the
Employee table except Salary. Users of the
database view can see and update all information except the employee's
salary.
• To combine information from multiple tables for easy access.
In DataWindow Designer, you can create single- or multiple-table database
views. You can also use a database view when you define data to create a new
database view.