In SQL Server 2000, if Fred created a table called “Mytable” in the “Pubs” database on the “Usaserver”, the fully qualified name would be Usaserver.Pubs.Fred.Mytable.

A conventional database like Microsoft SQL Server, MySQL, PostgreSQL, or Oracle Database uses a schema—a formal definition of how data inserted into the database will be composed.