How to Modify a Database Column in Supportworks: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
No edit summary |
||
| Line 16: | Line 16: | ||
Opencall.AssignCount column from an Int to a VarChar. | Opencall.AssignCount column from an Int to a VarChar. | ||
1. Export schema from physical database | '''1. Export schema from physical database''' | ||
Run Supportworks database Schema Editor and from the Database menu select | Run Supportworks database Schema Editor and from the Database menu select | ||
“Export Specification from physical database…” or click the icon. | “Export Specification from physical database…” or click the icon. | ||
The following screen will appear. | The following screen will appear. | ||
Latest revision as of 14:20, 19 May 2015
| Status: | Published |
|---|---|
| Version: | 1.0 |
| Authors: | HTL QA |
| Applies to: | Supportworks Version 7.0 onwards |
How to Modify a Database Column in Supportworks
This document details how to modify a Database Column using the Supportworks Database schema Editor. The example below changes the type of the Opencall.AssignCount column from an Int to a VarChar.
1. Export schema from physical database
Run Supportworks database Schema Editor and from the Database menu select “Export Specification from physical database…” or click the icon. The following screen will appear.