>> 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 ? This is a problem of xsql, which sends the create index statement to the SAPDB kernel twice. If possible please use another client tool (SQLStudio for example). Regards, Thomas -- Thomas Anhaus SAP DB, SAP Labs Berlin [EMAIL PROTECTED] http://www.sapdb.org/ _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
