web master >> sql manager

sql manager

SQL Manager for DotNetNuke (5.6+) is a DNN Module that allow users easily manage sql tables and edit sql queries in a performed and more accessible manner.

Buy on store.dotnetnuke.com
Module Settings

In modules settings users have to set the connection string of the database. If the connection string is not set, the default SiteSqlServer will be used.

SQL Manager Preview





Usage information

In search text box you can search for a table by inserting it's name or a part of the name itself: in tables dropdownlist all found tables will appear, but by default it contains all the tables of the current database istance. By clicking on "Select Top" button you will make a select top... query with 100 elements by default. "Columns detail" button will show all details of all the columns of the selected table. "PK" will show primary keys, "FK" foreign keys, "IX" indexes while "size" will show table size. In columns dropdownlist you see all the columns of the selected table. If you want to edit a general query just write it in the central multiline text box: while you are writing a query you can add table name and column name by clicking on "Add Column Name" button or "Add Table Name" button. Once finisched writing query just click on "Execute" button and you will see all row affected by your query.



Copyright © DnnEagles 2011
Friend Link: Timberland 6 Inch Boots Herren Nike Air Max 2016 Nike ELASTICO Finale III Street TF Adidas Messi 16.3 IC MBT Lami Damen TIMBERLAND CHUKKA BOOTS Adidas Superstar 2 Shoes Friend Link: NIKE ROSHE TWO FLYKNIT SHOES AIR JORDAN 23 Adidas Originals NMD Adidas Yeezy Boost 550 Adidas Tubular Schuhe Adidas Springblade Schuhe ADIDAS D ROSE 7 MEN Friend Link: Adidas Originals Pride Pack Adidas Originals Stan Smith W Adidas Originals ZX 500 Adidas Climacool Boat Lace NIKE AIR FORCE 1 07 HIGH MBT BARIDI WOMEN AIR JORDAN 2 MEN