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


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.


All Orion Platform versions


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 AS table_name, SCHEMA_NAME(schema_id) AS schema_name, AS column_name
    FROM sys.tables AS t
    INNER JOIN sys.columns c ON t.OBJECT_ID = c.OBJECT_ID
    WHERE LIKE '%NodeID%' /* adjust filter criteria here */
    ORDER BY schema_name, table_name;

Last modified