what is the difference about SCHEMA in sql server 2005 and sql server 2008?

what is the difference about SCHEMA in sql server 2005 and sql server开发者_运维问答 2008?

I don't know that any changes were made to the SCHEMA implementation between 2005 and 2008, although I believe if we are talking about 2005 RTM, there were some slight changes to system functions that came about in 2005 SP2, for example OBJECT_SCHEMA_NAME() was added, and OBJECT_ID() was modified to add a second parameter, database_id. So you would notice these differences if comparing functionality in 2005 RTM or SP1 to functionality in 2008.

Perhaps if you have a more specific question about schema (or perhaps you mean something completely different than how I interpreted) - can you give more details about what information you are after?