Schema Question:
Download Questions PDF

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

Answer:

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.

Download Schema Interview Questions And Answers PDF

Previous QuestionNext Question
What is meant by the Waterfall Model?Define XML schema permission "GRANT permission [ ,...n ] ON"?