> select index_name,table_name from user_indexes INDEX_NAME | TABLE_NAME | ---------------------------------------------------------------------- IX_TESTTAB_NAME | TESTTAB | * Ok > drop table testtab * Ok > select index_name,table_name from user_indexes * 100: Row not found > create table testtab (id serial(42),name varchar(200)) * Ok > create index ix_testtab_name on testtab (name) * -6008: Duplicate index name > select index_name,table_name from user_indexes INDEX_NAME | TABLE_NAME | ---------------------------------------------------------------------- IX_TESTTAB_NAME | TESTTAB | * Ok >
Why the error-message after create index ? Why is the index created in spite of the error-message ? _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
