How to Modify a Database Column in Supportworks: Difference between revisions
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...") |
No edit summary |
||
| (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.