开发者

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 > Prope开发者_C百科rties 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!

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


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.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜