CREATE TABLE [dbo].[Table] - what does the dbo part mean?

Question

When I go to create a new Table, I'm aware that I can do something like:

CREATE TABLE Users
(
    [Id] INT NOT NULL PRIMARY KEY
)

But what does the [dbo]. part mean in the following example:

CREATE TABLE [dbo].[Table]
(
    [Id] INT NOT NULL PRIMARY KEY
)

Thats the schema: http://stackoverflow.com/questions/1062075/why-do-table-names-in-sql-server-start-with-dbo — razethestray, Nov 09 '13 at 01:23

score 3 · Accepted Answer · edited May 23 '17 at 10:31

3

That is the Schema that the table is being placed in. This is not actually required as dbo is the default schema and any objects referenced without schema specified are assumed to be in dbo.

If you were to create your own schema eg:

CREATE SCHEMA [MySchema] AUTHORIZATION [dbo]

You would then have to reference any objects in it as [MySchema].[MyObject]

More on S.O.

edited May 23 '17 at 10:31

Community

1
1

answered Nov 09 '13 at 01:27

razethestray

666
1
9
20

score 1 · Answer 2 · edited May 23 '17 at 12:21

1

"dbo" is a special schema, it is the database-owner. It exists in every database, but you can add schemas (like folders) to databases

From: https://stackoverflow.com/a/4824493/677480

edited May 23 '17 at 12:21

Community

1
1

answered Nov 09 '13 at 01:31

pjwilliams

300
2
10

CREATE TABLE [dbo].[Table] - what does the dbo part mean?

2 Answers2