CODEWITHSUNDEEP
mysqldatabaseduplicatescreate-table
DBA_assis
DBA_assis

Reputation: 25

Prevent Duplicate Table entry in Database

I'm trying to Create new table for record of each company and its information. And for that I'm using simple Create query. Is there any way to prevent duplication of Table?

Upvotes: 0

Views: 139

Answers (1)

Gordon Linoff
Gordon Linoff

Reputation: 1270091

In every database that I know of, duplicate table names are not allowed. In some, there is a third element, the schema, but I assume everything is in the same schema.

In other words, trying to create a duplicate will cause an error. Try it.

By the way, you should always tag your questions with the database you are using.

Upvotes: 3

Related Questions