Error while creating index in SQL Azure

Question

I'm trying to create an index on table [Children] in SQL Azure but get the following error:

The operation failed because an index or statistics with name 'IX_Children_ParentID' already exists on table 'Children'.

As far as I can see there's no index or statistics with this name. The following command returned zero results so there shouldn't be any indexes or statistics. Is that correct?

SELECT object_id, name FROM sys.stats WHERE name = 'IX_Children_ParentID'
UNION ALL
SELECT object_id, name FROM sys.indexes WHERE name = 'IX_Children_ParentID'

UPDATE: Changed the query in response to @Shark's anwer.

My SQL command for creating the index:

CREATE INDEX IX_Children_ParentID
ON [myschema].[Children]
(
    [ParentID] DESC
)

Before this error occurred I had problems with timeouts while creating the index. Could this be caused by some remnants?

Answer 1

The catalog view sys.all_objects won't show nonclustered indexes. Here's the query you should be using:

select
    object_name(object_id) as table_name, 
    name as index_name
from sys.indexes
where name = 'IX_Children_ParentID'

Or to get all of the indexes for that table:

select
    object_name(object_id) as table_name, 
    name as index_name
from sys.indexes
where object_name(object_id) = 'Children'