DevOps Cloud (ADM)
Cybersecurity
IT Operations Cloud
How can I view SilkCentral Test Managers Database Tables\View properties?
In order to view SCTM"s Database Tables/View properties you need to ensure you have SQL server Enterprise Manager or equivalent installed. Go to:
Start/Programs/Microsoft SQL Server/Enterprise Manager
Once Enterprise Manager is open, right click on the Table/View and select "Design View"/"Design Table.
For example you will see the Views design as per screenshot below:
This shows the SQL
query used to return the view, the column properties and a
graphical representation of the tables used.