プロパティ

www.altova.com このトピックを印刷 前のページ 1つ上のレベル 次のページ

ホーム >  DatabaseSpy プロジェクト >

プロパティ

In DatabaseSpy you can view properties by selecting objects in (i) the プロジェクトウィンドウ, (ii) the オンラインブラウザー, (iii) デザインエディター ウィンドウ, or (iv) the Data or スキーマの比較ウィンドウ . 更に、 you can define properties for designs, SQL files, and comparison files that have been added to a project. The properties are displayed in プロパティウィンドウ.

 

Changing a property in the Property Window or in デザインエディター ウィンドウ automatically generates an SQL change script which appears in the in the データベース構造変更スクリプト window either automatically or after you have clicked the 変更スクリプトの更新 ic_update-change-script ボタン, depending on how you have configured the 変更スクリプト options. Properties that cannot be edited are grayed out.

 

オンラインブラウザー内で、 properties for all データベースオブジェクトs as well as for any active data source connection, its database and/or schema(s) can be viewed in プロパティウィンドウ. When folders are displayed, clicking a folders shows an overview of the folders content in プロパティウィンドウ.

 

The properties that are displayed in プロパティウィンドウ depend on the データベースオブジェクト that is currently selected オンラインブラウザー内で、 デザインエディター, or Comparison ウィンドウ。 If an object has child objects, the content of プロパティウィンドウ changes in accordance with the level to which you expand the object, that is, only properties for expanded items are displayed in プロパティウィンドウ.

 

For データソース connection, DatabaseSpy displays the same properties like in the プロジェクトウィンドウ。 The properties that are displayed when you click on a database in the オンラインブラウザー are for information purposes only and cannot be changed.

 

Object count

For every データベースオブジェクト that contains child objects, an overview section is displayed. This section provides hyperlinks for counting the number of the individual children of the データベースオブジェクト as well as a hyperlink for counting all children of the object. Note that the count is retrieved automatically if you expand the object in the オンラインブラウザー or show a table in デザインエディター ウィンドウ.

 

To retrieve the number of child objects in the 概要 section of プロパティウィンドウ, you have therefore the following options:

 

Click the "Update all Counts" hyperlink to retrieve the count for all child objects.

tab_properties-update-all-counts

Click the "Update Count" hyperlink for an individual データベースオブジェクト to retrieve the count for this specific item.

tab_properties-update-FK

Show a table in デザインエディター ウィンドウ; this automatically retrieves the count for all child objects of the table.
テーブルを右クリックし、 「展開 | 子」 をコンテキストメニューから選択します。 This expands all sub-folders of the table in the オンラインブラウザー and thus shows the number of child objects in the table properties.
Expand one or more sub-folders in the オンラインブラウザー and then click the table again. The number of items contained in the folder is displayed in the table properties.

 

Tables

Table properties can be viewed (i) in プロパティウィンドウ and (ii) to some extent in the table design. If properties are displayed in プロパティウィンドウ, it makes no difference whether a データベースオブジェクト is selected in the オンラインブラウザー or in デザインエディター ウィンドウ.

 

The 概要 section lists the child objects of the table and you can retrieve the number of the individual children separately. In the Constraints section, you can see at a glance which constraints are defined on which columns for the table. チェック制約 on table level can even be edited in this section. Whereas the General section provides only read-only information, you can enter a new or change an existing description for the table in the 説明 section.

 

A table may contain the following sub-folders:

 

Columns

When you expand the Columns sub-folder under a table in the オンラインブラウザー or expand the Columns section in a table design in デザインエディター, and select a column, the column properties are displayed in プロパティウィンドウ. Here you can change the データ型 and the Nullable property in the General section, or enter a description in the 説明 section. The remaining sections (概要 and Advanced) are read-only.

 

Constraints

The constraints properties for チェック制約 include the name of the table the constraint is assigned to, the expression used for the constraint, and a description. You can change the expression and the description in プロパティウィンドウ.

 

Keys

If you select a primary or 一意キー in the オンラインブラウザー or in デザインエディター ウィンドウ, プロパティウィンドウ displays the number of columns that are used to build the key as well as the table the key is assigned to. For 外部キー, also the referenced tables and columns as well as the action on delete and update are displayed in the properties.

 

Indexes

Index properties show information such as the number of columns involved, index type, and the 列名 an index is assigned to. The Options section provides additional read-only information.

 

Views

In the properties for views, DatabaseSpy displays the number of columns that are included in the view (provided that the object count has been retrieved), and the schema in which the view is defined. The Advanced section shows additional read-only information.

 

XML スキーマ

The only option that you can change directly in プロパティウィンドウ for XML schemas is the Decomposition チェックボックス. Any other property is read-only in プロパティウィンドウ and can only be changed in the XML スキーマの管理 for databases ダイアログボックス.

 

Procedures

For procedures, only the number of parameters and the schema in which the procedure is defined are displayed in プロパティウィンドウ. If you expand a procedure to show the parameters, you can also display the データ型 and the direction mode of a parameter in プロパティウィンドウ. All properties for procedures are read-only.

 

Functions

The properties displayed for functions include the number of parameters, the schema, the Deterministic チェックボックス, and the language. If you expand a function to show the parameters, you can also display the データ型 and the direction mode of a parameter in プロパティウィンドウ. All properties for functions are read-only.

 

Note:The constraints information can only be displayed if all the table's children objects have already been loaded. This can be achieved in one of the following ways:

 

by expanding the table in the オンラインブラウザー
by generating an SQL ステートメント for that table in the SQL エディター
by showing the table in デザインエディター ウィンドウ

 

Changing table properties

All the table and columns properties that can be edited can be changed either in プロパティウィンドウ of the オンラインブラウザー or in the property window in デザインエディター ウィンドウ. In the table display in デザインエディター ウィンドウ, you can also edit the データ型 or check or uncheck the Nullable チェックボックス.

 

 

To change the properties of a column:

1.次のいずれかを実行してください:

 

オンラインブラウザー内で、 select a column and change its properties in プロパティウィンドウ of the オンラインブラウザー.
デザインエディターウィンドウ内で、 select a 列名, click the ball at the right edge of the table display and change the properties in the property window that appears.

 

The changed column ic_change-column アイコン appears to the left of the 列名 and the changed table ic_change-table アイコン appears to the left of the table name.

2.適応できる場合、 click the 変更スクリプトの更新 ic_update-change-script ボタン to update the change script.
3.データベース構造変更スクリプト ウィンドウ内で、変更スクリプトの実行 ic_execute-sql ボタンをクリックします。

(C) 2019 Altova GmbH