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