Geek Answers Handbook

Why is my new schema not showing in the table properties panel?

I am using SQL Server 2008 Express and Sql Server Management Studio 2008.

I am trying to associate a database table with a new schema.

I created a new scheme by going to Security-> Schemas in object explorer. I right-click on the folder and create a new scheme called "People" and set it as db_owner. This new schema now appears in the object explorer.

Now I would like to associate a table with this schema. I open the table in design mode and click on the drop-down list in the Properties panel of the table, which contains the available diagrams, but my newly created diagram is not visible.

I tried updating everything in the object explorer. Closing the design and reopening it, etc., But still it is not there.

Am I doing something wrong?

Can someone point me in the right direction?

+7
sql-server schema ssms
source share
2 answers

Sorted ... in the funniest way.

Apparently, updating the browser of objects at each hierarchical level is not enough.

I had to CLOSE sql management studio and then open it again. Then the list of schemas was updated and allowed me to link my new custom schema to a table.

IMO this is trash.

+15
source share

I will not follow you when you say: "Open the table in design mode, then click on the drop-down list." I have to ignore the list of my SQL Express.

Have you tried changing the schema through TSQL? The command is short:

ALTER SCHEMA "target schema" TRANSFER "source schema"."table name"; GO

Replace the target and source schema with the names of your schema.

-2
source share

More articles:


All Articles