Intellipaat Back

Explore Courses Blog Tutorials Interview Questions
0 votes
in SQL by (20.3k points)

This is from SQL Server 2008, ssms

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.

1 Answer

0 votes
by (40.7k points)

Follow these steps to create the SQL table under a different schema:

Step 1: Right-click on the Tables node and choose the New Table.

Step 2: Open the properties window (view -> Properties Window), with the help of table designer open.

Step 3: Now, you can change the schema that the table will be made in by choosing the schema in the properties window.

Related questions

0 votes
1 answer
0 votes
1 answer

Browse Categories