SQL Where Clause Search Tokens
SQL Where Clause Search tokens are the basic syntactical units of a SQL query, which comprise keywords, identifiers, strings, and other commands. When you build a SQL Where Clause query, you should use only the tokens allowed in Vantagepoint to ensure the successful execution of your SQL Where Clause search.
Use the Vantagepoint SQL Where Clause search functionality to test and validate SQL Where Clause searches. You must have the appropriate security role to create and run SQL Where Clause searches. For more information, see Set Up Role Security Access for SQL Where Clause Searches.
Valid Tokens for SQL Where Clauses in Vantagepoint
Because SQL Where Clause searches can impact database performance, we recommend that you work with your Administrator to identify and build SQL Where Clause searches.
The following table lists the tokens that are allowed for use in SQL Where Clause searches:
| SQL Where Clause Search Tokens |
|---|
| Add |
| Add Equals |
| All |
| Alter |
| Ampersand |
| And |
| Any |
| As |
| Asc |
| AsciiStringLiteral |
| AsciiStringOrQuotedIdentifier |
| Authorization |
| Backup |
| Bang |
| Begin |
| Between |
| BitwiseAndEquals |
| BitwiseOrEquals |
| BitwiseXorEquals |
| Break |
| Browse |
| Bulk |
| By |
| Cascade |
| Case |
| Check |
| Checkpoint |
| Circumflex |
| Close |
| Cluster |
| Coalesce |
| Collate |
| Colon |
| Column |
| Comma |
| Commit |
| Commute |
| Constraint |
| Contains |
| ContainsTable |
| Continue |
| Convert |
| Create |
| Cross |
| Current |
| CurrentDate |
| CurrentTime |
| CurrentTimestamp |
| CurrentUser |
| Cursor |
| Database |
| Dbcc |
| Deallocate |
| Declare |
| Default |
| Delete |
| Deny |
| Desc |
| Disk |
| Distinct |
| Distributed |
| Divide |
| DivideEquals |
| DollarPartition |
| Dot |
| Double |
| DoubleColon |
| Drop |
| Dump |
| End |
| EndofFile |
| EqualsSign |
| Errlvl |
| Escape |
| Except |
| Exec |
| Execute |
| Exists |
| Exit |
| External |
| Fetch |
| File |
| FillFactor |
| For |
| Foreign |
| FreeText |
| FreeTextTable |
| From |
| Full |
| Function |
| Go |
| GoTo |
| Grant |
| GreaterThan |
| Group |
| GroupBy |
| Having |
| HexLiteral |
| HoldLock |
| Identifier |
| Identity |
| IdentityColumn |
| IdentityInsert |
| If |
| In |
| Index |
| Inner |
| Insert |
| Integer |
| Intersect |
| Into |
| Is |
| IsNotNull |
| IsNull |
| Join |
| Key |
| Kill |
| Label |
| Left |
| LeftCurly |
| LeftParenthesis |
| LessThan |
| Like |
| LineNo |
| Load |
| Merge |
| Minus |
| ModEquals |
| Money |
| MultilineComment |
| MultiplyEquals |
| National |
| NoCheck |
| NonClustered |
| None |
| Not |
| Null |
| NullIf |
| Numeric |
| OdbcInitiator |
| Of |
| Off |
| Offsets |
| On |
| Open |
| OpenDataSource |
| OpenQuery |
| OpenRowSet |
| OpenXml |
| Option |
| Or |
| Order |
| Outer |
| Over |
| Precent |
| PercentSign |
| Pivot |
| Plan |
| Plus |
| Precision |
| Primary |
| Proc |
| Procedure |
| ProcNameSemicolon |
| PseudoColumn |
| Public |
| QuotedIdentifier |
| Raiserror |
| Read |
| ReadText |
| Real |
| Reconfigure |
| References |
| Replication |
| Restore |
| Restrict |
| Return |
| Revert |
| Revoke |
| Right |
| RightCurly |
| RightOuterJoin |
| RightParenthesis |
| Rollback |
| RowCount |
| RowGuidColumn |
| Rule |
| Save |
| Schema |
| Select |
| SemanticKeyPhraseTable |
| SemanticSimilarityDetailsTable |
| SemanticSimilarityTable |
| Semicolon |
| SessionUser |
| Set |
| SetUser |
| SEUser |
| Shutdown |
| SingleLineComment |
| Some |
| SqlCommandIdentifier |
| Star |
| Statistics |
| StopList |
| SubtractEquals |
| SystemUser |
| Table |
| TableSample |
| TextSize |
| Then |
| Tilde |
| To |
| Top |
| Tran |
| Transaction |
| Trigger |
| Truncate |
| TryConvert |
| TSEqual |
| UnicodeStringLiteral |
| Union |
| UnionAll |
| Unique |
| Unpivot |
| Update |
| UpdateText |
| Use |
| User |
| Values |
| Variable |
| Varying |
| VerticalLine |
| View |
| WaitFor |
| When |
| Where |
| While |
| WhiteSpace |
| Write |
| WriteText |