can i do this
Hi
can i make a two tables with same name.
(Vishal Mongia)
Web Development
Hi
can i make a two tables with same name.
(Vishal Mongia)
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.
Sort by Trending