Can I delete the primary index(will it be recreated automatically?).

[Former Member]

It seems a table does not have appropriate index(primary).

A field is missing.

I can not continue patching system. I am on WIN/SQL.

How could I overcome easiest the problem. Can I delete the index(will it be recreated automatically?). Sorry for my message beeing very elementar but i am substituting colleague who is on hollydays

[former_member184473 · Accepted solution]

Hello Jan,

If you use the DROP clause this index will not to be recreate automatically.

You can use transaction SE11 to manage the indexes in your table.

You can find more information in the MSDN website [Reorganizing and Rebuilding Indexes|http://msdn.microsoft.com/en-us/library/ms189858.aspx].

Regards,

Eduardo Rezende