Advanced SQL syntax for meta-data : LUSENET : DBAzine : One Thread

Pls can someone supply syntax examples for SQL statements that control/use/manipulate meta-data ie. Create Amend Access Right Integrity etc

Thnx Oh its urgent!

-- Quintan Quigley (, May 31, 2001


From your question it is difficult to understand just axactly what you are asking for. If you are talking about business metadata, then you would have to define the lexicon for the metadata to be stored in your repository/dictionary. If you are talking about system metadata, then any CREATE DDL SQL statement populates the relational catalog with system metadata. Of course, the syntax of the DDL will differ based on the DBMS you are using...

Sorry, I can't be much helpful than that, Craig S. Mullins BMC Software

-- Craig S. Mullins (, June 05, 2001.

Moderation questions? read the FAQ