Do table names with [Name1].[Name2] pattern differ from normal tables?

410 Views Asked by At

When I look at Microsoft's sample AdventureWorks database, I see the table names follow a pattern such as:

[Person].[Address]

Does this kind of specification differ from a normal pattern such as:

PersonAddress

Is it only for readability or is there some other point to it?

1

There are 1 best solutions below

0
On

It's SchemaName.TableName

So [Person].[Address] != PersonAddress

Instead it'll be Person.Address

The [] are optional, they exist because if you have special characters, or a reserve word in the object name, you will not be able to call the object without them.

For example select last name from people; is not going to work,

instead you need select [last name] from people;

You can find more information here.