Modifying Column Properties このトピックを印刷 前のページ 1つ上のレベル 次のページ

ホーム >  データベース構造の探索と変更 > デザインエディター内でのテーブルのデザイン >

Modifying Column Properties

When a column is selected either in the オンラインブラウザー or デザインエディターウィンドウ内で、 its properties are displayed in DatabaseSpy's Properties ウィンドウ。 更に、 you can show some of the properties (データ型, nullability, デフォルトの値, description, identity, increment, and seed) directly in デザインエディター ウィンドウ.



When you need to change the データ型 of a column, you can edit the Type field directly in the table design. DatabaseSpy assists you by displaying incomplete データ型 entries in gray and changing the color to black as soon as you have typed in a valid keyword. While you are typing, a ドロップダウンリスト containing the available データ型 is displayed. Incorrect syntax is marked in red. For データ型 requiring a length, you can also type in "max" and thus set the length to the maximum allowed value.



The Nullable チェックボックス can also be changed directly in the table design. Please note that NULL values are not permitted if a primary key is defined on that particular column and that you cannot deactivate the Nullable チェックボックス if NULL values are already present in the column.



Every データ型 has a default length defined that is automatically used when you select that particular データ型. For some データ型, you can increase or decrease this default length in プロパティウィンドウ. Please consider that existing values may be truncated if you decrease the データの長さ in an existing table.



In numeric columns, you can define the maximum number of digits to be used by a データ型.



The Scale property defines the maximum number of digits to the right of the decimal point in numeric and decimal columns.



You can add an individual description for each of the columns.

(C) 2019 Altova GmbH