Schema Interview Question:

Give syntax and examples for creating and dropping XML schema collection?

Submitted by: Murtaza

Syntax and example for creating and dropping XML schema collection:
★ CREATE XML SCHEMA COLLECTION [ <relational_schema>. ]sql_identifier AS Expression
★ relational_schema: identifies the relational schema name. Default is relational schema.
★ sql_identifier: is the SQL identifier for the XML schema collection.
★ Expression is a string constant or scalar variable. It can be a varchar, varbinary, nvarchar, or xml type.
★ DROP XML SCHEMA COLLECTION [ relational_schema. ]sql_identifier
relational_schema identifies the relational schema name.
sql_identifier is the name of the XML schema collection to drop.
Submitted by: Murtaza