Choose your database:

Partners

Testimonials

Johnattan Badden, Manager: "The software is easy to work with and most importantly, report management is extremely easy, even for a novice like me! I am able to create and edit my databases with a few clicks and easily maintain them afterwards. I highly recommend SQLite Maestro to educational institutions: it's easy and flexible, it is exactly what can be good for using in schools and colleges".

Mario Figueiredo: "I can safely forget all I know about SQL when using SQLite Maestro. It is that easy and intuitive to use. It is also nicely drawn with an easy and appealing interface that makes the sometimes boring tasks of database maintenance and administration more endurable.
The decision to support the non-commercial use of your software with a lower price is absolutely worth mentioning. For that alone, I thank you. For everything else, I say keep up the good work".

Add your opinion

Customers

Become a customer

SQL Maestro Group / Products / SQLite / SQLite Maestro / Documentation

Download

Buy

SQLite Maestro online Help

Return to chapter overview

The last wizard step allows you to edit the new object definition directly.

Use this step to edit the name of object been creating (New Object Name). By default SQLite Maestro generates the new object definition with the same name if the duplicating is to the source database, or like "%SOURCE_OBJECT_NAME%01" otherwise.

Note: the name of the object must be unique among all the object names in its container. Moreover, all the objects that are source of data need unique names among themselves. You can use any identifier that is allowed by SQLite server.

You can edit the result SQL statement manually, add or remove fields, change field types, using the New object definition text area. Click the Ready button to complete the operation.
Check the according boxes to Copy Data (only for tables) and to Open Object Editor after the duplicating.

Return to chapter overview

SQL Maestro Group wishes you a happy Thanksgiving!

We are pleased to grant you a 20% discount for all our products and bundles till the end of November!

Company news

May 5, 2021

SQLite Maestro 21.5 released

New version introduces new database encryption algorithms, support for generated columns, support for renaming and dropping columns using ALTER TABLE statement, and some other enhancements.

Nov 14, 2016

SQLite Maestro 16.11 released

New version introduces support for FTS5 extension and expression-based indexes, new encryption algorithms in data grids, updated data export and data import tools, and some other useful things.

Jan 12, 2015

SQLite Maestro 15.1 released

New version comes with support of user authentication and management, read-only database connections, colored tabs, and some other new features.

More news

Feature of the day

Object Duplicating

You can make a copy of a database object by dragging it from one database to another in SQLite Maestro.

Query Builder

SQLite Maestro allows you to build and edit SELECT queries as visual diagrams.

SQLite Maestro online Help

Modifying new object definition

Thanksgiving Sale