Primary Key Listing – If your table has keys defined, they will be listed through this option.Īdditionally, you also have the ability to run SQL commands directly through DbVisualizer.Row Count – While running a count through STRSQL is not overly difficult, the ability to have this option on a button makes it quick and easy to determine the number of rows in the table.Additionally, you have the added bonus of seeing more than 80 characters across at a time Some notable features that make this option stand out is the ability to filter out data and export data out to Excel. Data View – This option shows you the result set for the table you are examining.Field type, length, and other basic information are available through this option. Columns – A very basic listing of all the fields that exist in the file.Here is a brief recap of these useful tools: For starters, I am brought to a screen that gives me buttons for options, such as: Column Listing, Data View, Row Count, and Primary Key Listing.
#DBVISUALIZER CONNECT TO SQL SERVER FULL#
Not only does it show me a full listing of all of my tables, there is a lot of functionality too. I found the “Table” view to deliver the most functionality. After drilling into a specific library, you can then see tables, views, system tables, aliases, and procedures loaded into that library. After installation and setup, I am brought to a listing of all libraries on my database in a clean, well organized graphical interface.
#DBVISUALIZER CONNECT TO SQL SERVER FOR FREE#
95% of the time these tools were open exclusively for examining data through the SQL Manager.Īfter being frustrated that too many programs were running to do essentially the same thing, I kept thinking there has got to be a better way.ĭbVisualizer is a product that is available for Free (Though they also have options to purchase). Recently, I began noticing that I would have multiple AS400 sessions open, along with MS SQL Enterprise Manager.
When working with m-Power, I often find myself accessing the data-base through SQL for a variety of reasons: