MyEclipse Logo
 

MyEclipse SQL Server & Sybase Feature Overview

Outline
download the latest MyEclipse version

help and support
 

1. Preface

This document was written using MyEclipse and SQL Server 2005 Express. All screenshots are based upon the default user interface settings for MyEclipse and Windows XP. However, if you experience difficulty with the instruction of this document, please see the User Feedback section for how to provide feedback to the MyEclipse documentation team.


 

2. Requirements

Below is a list of requirements for this Tutorial:

  1. MyEclipse (see Resources for a download link)
  2. Microsoft SQL Server or Sybase Database

3. Introduction

The extended SQL Server and Sybase features described in this document are available only to MyEclipse Professional subscribers.
Extended features currently cover Procedures, Functions and Triggers and Views. More features will be added in future releases.


Figure 1. Overview of extended Nodes supported by MyEclipse


4. Node Types & Features


4.1 View



Figure 2. Generate DDL for Views


Figure 3. View Info


4.2 Procedure



Figure 4. Open Procedure


Figure 5. Procedure Info


Figure 6. Run Procedure


4.3 Function (SQL Server Only)



Figure 7. Open Function


Figure 8. Function Info



Figure 9. Run Function


4.4 Trigger



Figure 10. Open Trigger


Figure 11. Trigger Info


4.5 Show sp_help

The "Show sp_help" action returns additonal information for any object and displays it in the SQL Results view. It is demonstrated here with a Procedure node.

Figure 12. Show sp_help


5. User Feedback

If you have comments or suggestions regarding this document please submit them to the MyEclipse Documentation Forum.


6. Resources