I have partioned my SQL Server 2008 database tables up using schemas to logically group tables together as [SchemaName].[TableName]
Also this gives me greater access control.
If one looks at the metadata the schema name is not that visible. One has to highlight a table to see what schema it belongs to.
I cloned an existing table present in schema into a table of the same name in a different schema.
When looking at the metadata, both tables are present but one has to highlight each table to see which schema it belongs to.
I can see this as a potential area for making mistakes.
It is possible to make the schema more visible with the current version?
Will this be addressed in the next version (2010)?