JAVASCRIPT

Retrieving SQL Server 2000 Constraints Information using Client-side JavaScript

This article mainly concentrates on retrieving SQL Server 2000 constraints information using client-side JavaScript. CHECK constraints, Primary and Foreign Keys, and other kinds of constraints are covered.

Author Info:

By: Jagadish Chaterjee

Poor Best

Rating:

/ 4

May 30, 2006

TABLE OF CONTENTS:

· Retrieving SQL Server 2000 Constraints Information using Client-side JavaScript
· How to retrieve all Primary Keys and Foreign Keys existing in a SQL Server 2000 instance using JavaScript
· How to retrieve only the Primary Keys of all tables in all databases existing in a SQL Server 2000 instance using JavaScript
· How to retrieve only the Foreign Keys of all tables in all databases existing in a SQL Server 2000 instance using JavaScript
· How to retrieve all the unique keys existing in all tables from all databases of a SQL Server 2000 instance using JavaScript
· How to retrieve all rules from all databases of a SQL Server 2000 instance using JavaScript

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html>
      <head>
            <title></title>
            <meta name="GENERATOR" content="Microsoft Visual Studio .NET 7.1">
            <meta name="vs_targetSchema" content="http://schemas.microsoft.com/
intellisense/ie5">
            <script id="clientEventHandlersJS" language="javascript">
<!--

functionButton1_onclick() {
      var locator = new ActiveXObject ("WbemScripting.SWbemLocator");
      var service = locator.ConnectServer(".","rootMicrosoftSQLServer");
      var properties = service.ExecQuery("SELECT * FROM MSSQL_Rule");
      var e = new Enumerator (properties);
      document.write("<table border=1>");
      dispHeading();
      for (;!e.atEnd();e.moveNext ())
      {
            var p = e.item ();
            document.write("<tr>");
            document.write("<td>" + p.Name + "</td>");
            document.write("<td>" + p.Text + "</td>");
            document.write("<td>" + p.DatabaseName + "</td>");
            document.write("</tr>");
      }
      document.write("</table>");
}

functiondispHeading()
{
      document.write("<thead>");
      document.write("<td>Name</td>");
      document.write("<td>Text</td>");
      document.write("<td>Database</td>");
      document.write("</thead>");
}

//-->
            </script>
      </head>
      <body>             <INPUT id="Button1" type="button" value="Button" name="Button1"
language="javascript" onclick="return Button1_onclick()">
      </body>
</html>

The above code would automatically list all the rules existing in an entire SQL Server 2000 instance belonging to the client. To retrieve this information, I used a built-in class, “MSSQL_Rule” available in the “rootMicrosoftSQLServer” namespace. The “for” loop I used in the above code iterates for every rule present in the SQL Server database and finally retrieves only the properties of that rule.

Any comments, suggestions, bugs, errors, feedback etc. are highly appreciated at jag_chat@yahoo.com.

DISCLAIMER: The content provided in this article is not warranted or guaranteed by Developer Shed, Inc. The content provided is intended for entertainment and/or educational purposes in order to introduce to the reader key ideas, concepts, and/or product reviews. As such it is incumbent upon the reader to employ real-world tactics for security and implementation of best practices. We are not liable for any negative consequences that may result from implementing any information covered in our articles or tutorials. If this is a hardware review, it is not recommended to open and/or modify your hardware.