Return
-
Title
Rebuild table function forgets to drop primary key index -
Description
When rightclicking in the schema browser on a table, and choose the rebuild table, the function adds "DROP INDEX" after dropping primary key constraint, and forgets to actually drop the index before recreating the index.
Example: ALTER TABLE SCHEMA.TABLE_NAME DROP CONSTRAINT PK_TABLE_NAME DROP INDEX;
[Error] Syntax check (2: 66): ERROR line 2, col 66, ending_line 2, ending_col 70, Found 'INDEX', Expecting: ( COLUMN COLUMNS CONSTRAINT CONSTRAINTS PRIMARY SUPPLEMENTAL UNIQUE UNUSED
Sign In Required
You need to be signed in and under a current maintenance contract to view premium knowledge articles.