CODEWITHSUNDEEP
sql-serversql-server-2000
Win
Win

Reputation: 62290

SQL Server 2000 - How to create a new table in existing database with prefix dbo?

All existing tables are with prefix dbo.TableNames

When I create a new table, it creates as login.MyTable instead of dbo.MyTable.

The screenshot is Security > Properties of my login.

Could you please show me step by step (I am not familiar with SQL securites) how to solve this problem?

Thanks in advance!

enter image description here

Upvotes: 1

Views: 3174

Answers (1)

Yuck
Yuck

Reputation: 50855

That means your default schema is your username (assuming that you mean login is actually a username like win and not really login). If you're using the UI table designers it will select that schema for you. You can try using:

CREATE TABLE dbo.TableName (
  -- some columns
);

But you may not have access to the dbo schema.

Upvotes: 2

Related Questions