Anonymous
Anonymous Asked in Cars &Transportation ยท 2 weeks ago

Can database have multiple tables?

Contents
  1. Can we create multiple tables in a single database?
  2. Can a database have multiple tables with same name?
The majority of databases you'll work with as a developer will have more than one table, and those tables will be connected together in various ways to form table relationships.


Can we create multiple tables in a single database?

No, we can't. A table can have only one Primary Key. The Primary Key can be defined on a single column or more than one columns.

Can a database have multiple tables with same name?

You can have tables of the same name only if they are in separate databases, and you use the database name as a qualifier.

Related Questions

Relevance
Write us your question, the answer will be received in 24 hours