Choose your database:
MS SQL Server
SQL Anywhere

Subscribe to our news:
Jim Salmons: "That is excellent news! I will look forward to a future update with these features. It will be attention to such details that further distinguishes your excellent products from the competition.

As always, I appreciate your great products and your demonstrated customer service is equal to the high quality of your products".
Kevin Settler: "If you need the job done right and on time, do it with MS SQL Maestro on your team. The software is a pleasure for us. SQL Maestro Group do excellent work and are dedicated to producing products that all can be proud of".


Add your opinion

MS SQL Maestro: Product Tour

Features of MS SQL Maestro:

Working with Tables

MS SQL Maestro provides wide opportunities to create and edit objects. Each object is created and edited within the appropriate wizard and handy editor.

Moreover, the wizards allow to create objects at the same time with the objects' subitems. Easily understandable wizard steps allow you to specify all table properties and also all table fields, indexes, foreign keys, default constraints, checks, and triggers.

Database Object Editors are the basic MS SQL Maestro tools for working with existing objects. The proper editor can be opened automatically after the object is created. You can also open the necessary object editor with the corresponding items of popup menus of the Explorer Tree, Object Manager or Object Browser.

Most of editors (for example, Table Editor) consists of a several tabs: Properties, Subitems, Data, Dependencies, Permissions, and SQL. Every tab allows you to set corresponding table characteristics.

So, to edit main table properties such as name, owner, file group and data of creating use the Properties tab.

The Subitems tab of the Table Editor is very helpful to manage table subobjects: fields, indexes, foreign keys, checks, default constraints, triggers, and foreign key references. Just choose the appropriate part and edit the grid.

The main parts of each Object Editor are Data and Permissions tabs. 

To practice table data management select the Data tab. For your convenience it was supplied with two view modes: as a table and as info cards.

The Permissions tab is provided to control users' permissions on the table. The Dependencies one represents database objects depending on and referencing by the current table. The SQL definition of the table is also available.

Back Next