Submit a ticketCall us

Looking to compare latest NPM features with previous versions of NPM?
The NPM new feature summary offers a comparison of new features and improvements offered with this release.


Home > Success Center > Network Performance Monitor (NPM) > Find tables and views containing column with specific name

Find tables and views containing column with specific name

Table of contents
Created by Mariusz Handke, last modified by MindTouch on Jun 23, 2016

Views: 6 Votes: 1 Revisions: 5


This article provides information on how to find tables and views containing column with specific names in the database, which may be useful while working on Orion and facing issues.


All Orion Platform versions


Note: In the following example, all tables and views where some column names contain NodeID):

  1. Make sure to backup 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
22:22, 22 Jun 2016