Difference between revisions of "How to Modify a Database Column in Supportworks"
Jump to navigation
Jump to search
(Created page with "{{Template:Basic Cover |title=How to Modify a Database Column in Supportworks|type=FAQ |htl=Y }} {{Template:Basic Status |status=Published |version=1.0 |authors=HTL QA |appli...") |
|||
| (One intermediate revision by the same user not shown) | |||
| Line 12: | Line 12: | ||
== How to Modify a Database Column in Supportworks == | == 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. | ||
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.