Discussion Locked

can i do this

0 helpful
5 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Hi

can i make a two tables with same name.

(Vishal Mongia)

5 replies

by donq

Data Modeling rules (for ALL ODBC database products + VB and C++ database engines) require UNIQUE Table names so the computer knows which Table to look the answer up from.

Field Names can't be duplicated within a single Table either. You can always add a "1" or "2" after names thar are similar if data modeling and/or proper normalization aren't a concern???

Good Luck.

by andrew

You can have tables with the same names as long as they have different owners.

database.dbo.table1
and
database.fred.table1

are distinct.

This discussion is closed to new replies.