Creating Table in SSMS (SQL Server)

Question

When I create a table using the interface with SSMS the table "prefix" automatically is set to

MyCompanyName\MyUserID.tableName.

However when I create a table with a query I am able to set the "prefix" to dbo.tableName.

MY 2 questions are

 (1). What does this "prefix" mean?  
 (2). How do I set the "prefix" to dbo using the SSMS interface?

I've done some research but can't figure out whether it refers to the schema (which I don't know anything about) or the user. Any help would be much appreciated. Thank you in advance!

-Charlie

The "prefix" you are referring to is the Schema which allows you a number of extra features in SQL, like permissions to that specific schema, or allowing you to group tables together in a database, for example. — Jacob H
– Jacob H, Commented Jun 1, 2017 at 15:21

Backs · Accepted Answer · 2017-06-01 15:22:08Z

1

This "prefix" is schema name.

You can change it in SSMS in property page (press F4 to open):

answered Jun 1, 2017 at 15:22

Backs

25k5 gold badges66 silver badges92 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Gary Fowler · Accepted Answer · 2017-06-01 15:23:58Z

0

It's simply adding the schema name as a prefix.

Sorry, covered in other answers above - I was 30 secs too late.

answered Jun 1, 2017 at 15:23

Gary Fowler

11 bronze badge

Collectives™ on Stack Overflow

Creating Table in SSMS (SQL Server)

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related