Import schema components into a database.
Syntax
CREATE XML SCHEMA COLLECTION [relational_schema.]sql_identifier AS Expression
Key
relational_schema The relational schema name.
sql_identifier SQL identifier for the XML schema collection.
Expression A string constant or scalar variable.
(varchar, varbinary, nvarchar, nvarbinary, or xml type)
The variable in the example below is of nvarchar(max) type. The variable can also be of xml data type, in which case, it is implicitly converted to a string.
DECLARE @MySchemaCollection nvarchar(max)
Set @MySchemaCollection = N' copy the schema collection here'
CREATE XML SCHEMA COLLECTION MyCollection AS @MySchemaCollection
"There are people who put their dreams in a little box and say, "Yes, I've got dreams." Then they put the box away and bring it out once in awhile to look in it, and yep, they're still there. These are great dreams, but they never even get out of the box.” ~ Erma Bombeck
sys.xml_schema_collections
sys.xml_schema_namespaces
DROP XML SCHEMA COLLECTION