blocks|key|752430|text|使用CREATE+SCHEMA语法，或者在SSMS中，向下钻取数据库->+YourDatabaseName+->安全->架构。右键单击Schemas文件夹并选择"New+Schema...“|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|752431|entityMap|0|LINK|mutability|MUTABLE|url|http://msdn.microsoft.com/en-us/library/ms189462.aspx^0|2|D|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@$A|M|B|N|1|O]]|C|$]]|$1|D|3|-4|5|6|7|P|8|@]|9|@]|C|$]]]|E|$F|$5|G|H|I|C|$J|K]]]]

Use the <a href="http://msdn.microsoft.com/en-us/library/ms189462.aspx" rel="noreferrer">CREATE SCHEMA</a> syntax or, in SSMS, drill down through Databases -> YourDatabaseName -> Security -> Schemas. Right-click on the Schemas folder and select "New Schema..."

blocks|key|968067|text|将模式添加到现有表的最佳方法:右键单击特定的表-->设计-->在management+studio下面右视看到Properties窗口，选择模式并单击它，看到下拉列表并选择您的模式。更改模式后，保存它。然后就会发现它会改变你的模式。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|968068|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

Best way to add schema to your existing table: Right click on the specific table-->Design -->
Under the management studio Right sight see the Properties window and select the schema and click it, see the drop down list and select your schema. After the change the schema save it. Then will see it will chage your schema.

blocks|key|752499|text|您可以尝试这样做：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|752500|use+database
go

declare+@temp+as+int
select+@temp+=+count(1)+from+sys.schemas+where+name+=+'newSchema'

if+@temp+=+0+
begin
++++exec+('create+SCHEMA+temporal')
++++print+'The+schema+newSchema+was+created+in+database'
end+
else+
print+'The+schema+newSchema+already+exists+in+database'
go|code-block|syntax|javascript|752501|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

You can try this: 

<pre><code>use database
go

declare @temp as int
select @temp = count(1) from sys.schemas where name = 'newSchema'

if @temp = 0 
begin
 exec ('create SCHEMA temporal')
 print 'The schema newSchema was created in database'
end 
else 
print 'The schema newSchema already exists in database'
go
</code></pre>

blocks|key|752514|text|这里有一个技巧，可以轻松地检查模式是否已经存在，然后在它自己的批处理中创建它，以避免在它不是批处理中唯一的命令时尝试创建模式的错误消息。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|752515|IF+NOT+EXISTS+(SELECT+schema_name+
++++FROM+information_schema.schemata+
++++WHERE+schema_name+=+'newSchemaName'+)
BEGIN
++++EXEC+sp_executesql+N'CREATE+SCHEMA+NewSchemaName;';
END|code-block|syntax|javascript|752516|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

Here's a trick to easily check if the schema already exists, and then create it, in it's own batch, to avoid the error message of trying to create a schema when it's not the only command in a batch.

<pre><code>IF NOT EXISTS (SELECT schema_name 
 FROM information_schema.schemata 
 WHERE schema_name = 'newSchemaName' )
BEGIN
 EXEC sp_executesql N'CREATE SCHEMA NewSchemaName;';
END
</code></pre>

blocks|key|968148|text|我使用的是这样的东西：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|968149|if+schema_id('newSchema')+is+null
++++exec('create+schema+newSchema');|code-block|syntax|javascript|968150|优点是，如果您将此代码放在一个长的sql脚本中，则可以始终将其与其他代码一起执行，而其他代码则很短。|968151|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|L|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|M|8|@]|9|@]|A|$]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

I use something like this:

<pre><code>if schema_id('newSchema') is null
 exec('create schema newSchema');
</code></pre>

The advantage is if you have this code in a long sql-script you can always execute it with the other code, and its short.

blocks|key|968175|text|在SQL+Server+2016+SSMS中，展开'DATABASNAME‘>展开'SECURITY’>展开'SCHEMA‘；右击'SCHEMAS’从弹出的左键单击'NEW+SCHEMAS...‘在打开的窗口上添加名称，并添加所有者，即dbo单击'OK‘按钮|type|unstyled|depth|inlineStyleRanges|entityRanges|data|968176|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

In SQL Server 2016 SSMS expand 'DATABASNAME' > expand 'SECURITY' > expand 'SCHEMA' ; right click 'SCHEMAS' from the popup left click 'NEW SCHEMAS...' add the name on the window that opens and add an owner i.e dbo click 'OK' button

How do you add a new schema to a database? I am creating a new table and would like to select my own schema from the properties list, but I don't know how to create it. I am using SQL Server Management 2008.

How to add a new schema to sql server 2008?

SQL Server

数据库

如何将新架构添加到数据库？我正在创建一个新表，并希望从属性列表中选择我自己的模式，但我不知道如何创建它。我正在使用SQL Server Management 2008。

问如何向sql server 2008添加新架构？
EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何向sql server 2008添加新架构？EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何向sql server 2008添加新架构？
EN