Use the Drop function
- Last UpdatedFeb 10, 2023
- 1 minute read
- PI System
- PI SQL Commander Lite 2021
- Developer
For PI SQL Client, you can drop a catalog, schema, view, table-valued function, or function table.
-
To drop a catalog, right-click a catalog folder, click Scripts > DROP CATALOG > New Query Editor Window and in the Query Editor pane execute the query.
-
To drop a schema, right-click a schema folder, click Scripts > DROP SCHEMA > New Query Editor Window and in the Query Editor pane execute the query.
-
To drop a view, right-click a view, click Scripts > DROP VIEW > New Query Editor Window and in the Query Editor pane execute the query.
-
To drop a function table, right-click a function table, click Scripts > DROP FUNCTION > New Query Editor Window and in the Query Editor pane execute the query.
Note: Alternatively, you can right-click the catalog folder, schema folder, view or function table and click Drop.
-
To drop a table-valued function, right-click a table-valued function, click Scripts > DROP FUNCTION > New Query Editor Window and in the Query Editor pane execute the query.