开发者

SQL Server.. trying to change schema name

开发者 https://www.devze.com 2023-01-24 21:22 出处:网络
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?

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

精彩评论

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

关注公众号