Managing Columns

Creating a New Column

1. Right-click Columns and select Create column.

   The Add New Column dialog box is displayed prompting you to add information about the new column. Enter the details and click Add.

   

2. You can view the added column in the corresponding table.

   Data Studio displays the status of the operation in the status bar.

Toggle Not Null

Follow the steps below to set or reset the Not Null option:

1. Right-click the selected column and select Toggle Not Null.

   Data Studio displays the Toggle Not-null Property dialog box.

2. Click OK to complete the operation successfully. Data Studio displays the status of the operation in the status bar.

Setting the Default Value of a Column

1. Right-click the selected column and select Set Column Default Value.

   A dialog box with the current default value (if it is set) is displayed, prompting you to provide the default value.

   

2. Enter the value and click OK. Data Studio displays the status of the operation in the status bar.

Changing the Data Type

1. Right-click the selected column and select Change Data Type.

   Change Data Type dialog box is displayed.

   

   

   The existing data type will be displayed as Unknown while you modify complex data types.

2. Select the Data type Schema and Data Type. If the Precision/Size spin box is enabled, enter the required details and click OK. Data Studio displays the status of the operation in the status bar.

Renaming a Column

1. Right-click the selected column and select Rename Column.

   The Rename Column dialog box is displayed prompting you to provide the new name.

2. Enter the name and click OK. Data Studio displays the status of the operation in the status bar.

Dropping a Column

1. Right-click the selected column and select Drop Column. This operation deletes the column from the table.

   A Drop Column dialog box is displayed.

2. Click OK to complete the operation successfully. Data Studio displays the status of the operation in the status bar.