SYSFILTERS

From Lianjapedia
Revision as of 06:17, 22 April 2020 by Yvonne.milne (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

Purpose

System table for QueryBuilder filters

See Also

QueryBuilder, System Tables

Description

The sysfilters table is stored in the system database and contains information on QueryBuilder filters.

Column Data Type Width Description
DATABASE C 80 Filter database
TABLE C 80 Filter table
ROLES C 255 Filter read permission roles
NAME C 80 Filter name
FILTER M 8 Filter query

Example

select * from system!sysfilters