New post
Question
· Jul 25, 2019

How to delete a large data lookup table

#Ensemble

Hello,

I have a large Data Lookup Table (> 150,000 records). It is too large to be opened from Ensemble --> Configure --> Data Lookup Tables to be deleted.

Is there another way that I can delete this table?

Thank you.

Discussion (3)0
Log in or sign up to continue
Jeffrey Drumm · Jul 25, 2019

You could do it with an SQL query:

DELETE FROM Ens_Util.LookupTable WHERE TableName = '<name of table>'

You can create the query either via the Management Console (System Explorer | SQL | Execute Query tab) or from the SQL Shell

JEFF>d $system.SQL.Shell()
SQL Command Line Shell
----------------------------------------------------
 
The command prefix is currently set to: <<nothing>>.
Enter q to quit, ? for help.
JEFF>>delete from Ens_Util.LookupTable where TableName = 'facLookup'
1.      delete from Ens_Util.LookupTable where TableName = 'facLookup'
 
3 Rows Affected
statement prepare time(s)/globals/lines/disk: 0.1893s/11322/125529/16ms
          execute time(s)/globals/lines/disk: 0.0021s/29/408/0ms
                          cached query class: %sqlcq.JEFF.cls27
---------------------------------------------------------------------------
0 0