November 25, 2008 at 9:41 am
I know there must be a simple way to do this ... When you create a new table graphically in SSMS, it wants to save it in the dbo schema when you save the new table. I'm guessing it depends on the default schema of the user who is authenticated and creating the table? Is there an easy way to manually specify the schema when you create the table? Thanks ...
November 25, 2008 at 10:17 am
You can specify the schema when you save the new table by inserting the schema name in front of the table name in the save table dialog box.
Greg
November 25, 2008 at 10:51 am
You can also open up the Properties window and set it there.
Best of all, try using TSQL. I think it's a heck of a lot easier to create tables there than with the GUI.
----------------------------------------------------The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood... Theodore RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply