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!
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.
精彩评论