In a given database what objects (Table, View, Index, Constraint, Trigger etc) can or can't have the same name?

So a table or view can have the same name if they are in a different schema. Is this true of other database objects?

For example, can an index have the same name of another if it is in another schema or for another table?

What are the rules for uniqueness around identifiers? (Not what we should do or naming conventions, but rather what is valid to do)

  • A related question on SO: stackoverflow.com/questions/1731997/… – McNets Feb 12 at 17:15
  • Yes that is similar and answers specifically for index, but what about tiggers or constraints etc. I guess i am trying to find the rules which define the uniques of a of an database objects name within a database. – I Donaldson Feb 12 at 19:20
  • Sorry i was asking about it in a round about way – I Donaldson Feb 12 at 19:20

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.