If you are wanting to use schemas in your database using database
professional then it is not that obvious.
You can add XML SCHEMA COLLECTIONs but where do they do to. They are tuck
away in the programability node under types, not the most obvious location.
Secondly if you create schemas using the ADD file option you will be
presented with a file like,.
CREATE
XML SCHEMA COLLECTION [dbo].[XMLSchemaCollection1]
AS
N'[xml_schema]'
Thats not too great if you already have your schemas and/or want to use the
schema tools in visual studio. You don't want to have to copy the schema into
the string bit of the declaration
The trick is to ....
...