Syntax for creating and dropping XML schema collection

          

Syntaxfor creating and dropping XML schema collection

<<Previous   Next>>

Syntax and example for creating and dropping XML schema collection - March 14, 2009 at 15:50 PM by Amit Satpute

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. 

<<Previous   Next>>
 



Write your comment - Share Knowledge and Experience


 

 
Latest placement tests
Latest links
 
Latest MCQs
» General awareness - Banking » ASP.NET » PL/SQL » Mechanical Engineering
» IAS Prelims GS » Java » Programming Language » Electrical Engineering
» English » C++ » Software Engineering » Electronic Engineering
» Quantitative Aptitude » Oracle » English » Finance
Home | About us | Sitemap | Contact us | We are hiring