Error -2714 There is already an object named 'usr_ossi_gcpa_orddata' in the database

After dropping the table from MS SQL Server 2008, I want to red-add it.  However, when I am adding it, I get the error "Error -2714 There is already an object named 'usr_ossi_gcpa_orddata' in the database"

I have checked the system tables, system columns and constraints.  I like to know where to check.
tgatif2000Asked:
Who is Participating?
 
kenwagersCommented:
Thanks for the list.  It seems it's not in the current database.  Are you sure you've set the current database using the 'USE <database>' command to the current area?

Could you try this in front of the CREATE TABLE statement?

IF EXISTS (SELECT 1 FROM INFORMATION_SCHEMA.TABLES
                  WHERE TABLE_NAME = 'usr_ossi_gcpa_orddata')
  DROP TABLE usr_ossi_gcpa_orddata
GO

<table create statement here>

0
 
kenwagersCommented:
Have you checked to see if there is a schema for that object?  That is likely the remaining part.

Alternatively, run this to identify what the object is:

select * from sys.objects where name = 'usr_ossi_gcpa_orddata'
0
 
tgatif2000Author Commented:
I have checked the objects and usr_ossi_gcpa_orddata is not there.
0
Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

 
kenwagersCommented:
Did the SELECT statement above return any rows?  Do you have 'sa' level authority?

Did you check for synonyms?
0
 
tgatif2000Author Commented:
SELECT statement returned the rows so I have 'sa' level authority.

there are no synonyms
0
 
kenwagersCommented:
What rows were returned by the select statement?  Can you post them here?
0
 
tgatif2000Author Commented:
Here is the result:
select-rows.JPG
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.