SAP Knowledge Base Article - Preview

1744025 - Index creation fails with incorrect syntax near keyword with

Symptom

You try to create a database index in transaction SE14 and it fails with:

CREATE
INDEX [<index_name] ON [table_name]
( <column_list> )
WITH FILLFACTOR = 90
WITH ( ONLINE=ON )
ON [PRIMARY]
Incorrect syntax near the keyword 'with'. If this statement is a common table expression or an xmlnamespaces clause, the previous statement must be terminated with a semicolon.
[...]
The SQL statement was not executed
Statements for Table <table_name> could not be executed
Request for <table_name> could not be executed

Index   could not be created completely in the database
Index <index_name> could not be created
Request for <table_name> could not be executed


Read more...

Environment

  • Microsoft SQL Server 2005 and Higher
  • SAP NetWeaver based systems running on Windows and SQL Server

Keywords

SE14,create index,Incorrect syntax near the keyword 'with' , KBA , BC-DB-MSS , SQL Server in SAP NetWeaver Products , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.