Viewing Table Properties¶
Perform the following operations to view the table properties:
Right-click the selected table and select Properties.
Data Studio displays the properties (General, Columns, Constraints, and Index) of the selected table in different tabs.
The following table lists the operations that can be performed on each tab page, as well as editing and refreshing operations. You can double-click a cell to edit it.
Tab
Operation
General
Save, Cancel, and Copy
Note
Only the Table Description field can be modified.
Column
Add, Delete, Save, Cancel, and Copy
CONSTRAINT
Add, Delete, Save, Cancel, and Copy
Indexes
Add, Delete, Save, Cancel, and Copy
For more information about Edit, Save, Cancel, Copy, and Refresh operations, see Editing Table Data.
Important
When viewing table data, Data Studio automatically adjusts the column widths for table view. Users can resize the columns as needed. If the text content of a cell exceeds the total available display area, then resizing the cell column may cause Data Studio to become unresponsive.
Note
A property window is displayed for each table.
If the property of a table is modified for a table that is already opened, refresh and open the properties of the table again to view the updated information on the same opened window.
If the text of a column contains spaces, word wrapping is applied to fit the column width. Word wrapping is not applied to columns without spaces.
The size of the column is determined by the maximum content length column.
After you refresh (click
) the Properties tab, the changes made to the table properties on the Object Browser are displayed.Pasting operation is not allowed in the Data Type column.