'Why is my new schema not showing in the table properites pane?

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 have created a new Schema by navigating to Security->Schemas in object explorer. I right clicked on the folder and created a new schema called 'People' and set the owner as db_owner. This new Schema now appears in object explorer.

I would now like to associate a table with this schema. I open the table in design view and click on the drop down list in the table Properties pane which contains the available schemas but my newly created schema is not visible.

I have tried refreshing everything throughout object explorer. Closing design view and reopening etc. but still it isn't there.

Am I doing something wrong?

Can anyone point me in the right direction please?

sql-serverschemassms


Solution 1:[1]

Step 1:

Open New Query(or existing query window). Ctrl+Shift+R in query window. It will refresh the intellisence cache or

Edit > IntelliSense > Refresh Local Cache

Also check if IntelliSense is enabled in

Tools > Options > Text Editor > Transact-SQL > Enable IntelliSense

Step 2:

refresh F5 the Object Explorer.

it worked for me

Similar Answer on stack overflow

Solution 2:[2]

I am not following you when you say "open the table in design mode then click on the drop down list". I must be overlooking the list on my SQL Express.

Have you tried to change the schema via TSQL? The command is short:

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

Replace target and source schema with your schema names.

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 Swap
Solution 2 RC_Cleland

Related Questions