开发者

SQL Server.. trying to change schema name

If I have a DB named myDB with one of the user defined Schema as Schema1..Is the following query correct if I want to create a simple table?

use myDB
CREATE TABLE Schema1.User开发者_运维知识库s
(UserID bigint NOT NULL,
UnID nvarchar(100),
UserName nvarchar(100),
PRIMARY KEY (UserID))

It prefixes dbo in the table name


Schema name wasn't correct in my query..sorted out the problem myself

0

上一篇:

下一篇:

精彩评论

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

最新问答

问答排行榜