Hi all, if I create a new schema:
CREATE SCHEMA MySchema
it appears in Sql Server Management Studio's schema, but it's not
obvious to me how to create a new table (or other object) under this
schema, without using the CREATE TABLE statement. How can I create a
new table under this schema using the designed in Managment Studio?
This is Sql Server 2005 (Standard Edition) I'm using.
Thanks!
RichardHello, Richard
When you create a new table using Management Studio, choose "View /
Properties Window" (or press F4) and select the desired schema in the
combo for the "Schema" property (under the "(Identity)" category).
Razvan
Tuesday, March 27, 2012
Create table in schema in Managment Studio
Labels:
appears,
create,
database,
management,
managment,
microsoft,
myschemait,
mysql,
notobvious,
oracle,
schema,
schemacreate,
server,
sql,
studio,
table
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment