Specifying the schema Name in the Table designer

I have seen a query in a popular forum and I would like to answer the query,
 
 When I create a table, it creates under dbo.
I would like to create it under a different schema, but when I use the 'New Table' dialog, I can never find the field where to specify this.
 
 
The answer is,
    You need to specify the schema name in the Properties window of the table.


1.jpg

Cheers,
Ebook Download
View all
Learn
View all