Submit a ticketCall us

WebinarUpcoming Webinar: How Help Desk and Remote Support Pays for Itself

Learn how help desk software can simplify ticketing management, allow you to track hardware and software assets, and accelerate the speed of IT support and service delivery. Gain insights on how remote support tools allow your IT team to maximize their efficiency and ticket resolution by expediting desktop troubleshooting, ultimately helping keep end-users happy and productive.

Register here.

Home > Success Center > Network Performance Monitor (NPM) > Find tables containing columns with a specific name

Find tables containing columns with a specific name

Table of contents
Created by Mariusz Handke, last modified by Melanie Boyd on Jun 04, 2018

Views: 17,152 Votes: 1 Revisions: 6

Overview

This article provides information on how to find tables containing columns with specific names in the database. This can be useful when you are working on Orion issues.

Environment

All Orion Platform versions

Steps

Note: The following example finds all tables with column names that contain NodeID):

  1. Make sure to back up your database, although dropping views has no impact on stored data.
  2. Open SQL Server Management Studio (SSMS).
    Note: You can also use Orion Database Manager
  3. Use the following query to drop all views:

    SELECT t.name AS table_name, SCHEMA_NAME(schema_id) AS schema_name, c.name AS column_name
    FROM sys.tables AS t
    INNER JOIN sys.columns c ON t.OBJECT_ID = c.OBJECT_ID
    WHERE c.name LIKE '%NodeID%' /* adjust filter criteria here */
    ORDER BY schema_name, table_name;

Last modified

Tags

Classifications

Public