|
Home > Archive > MS SQL Server > January 2006 > Create table in schema in Managment Studio
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Create table in schema in Managment Studio
|
|
| richardlowe@gmail.com 2006-01-31, 9:23 am |
| 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!
Richard
| |
| Razvan Socol 2006-01-31, 11:23 am |
| Hello, 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
|
|
|
|
|