Switch to: V11V10V9V8V7V6V5

Contextual Submenu - Generate SQL

According to selected command will be opened the SQL Editor with appropriate query and you will be able to execute, modify or copy it.

Common

Submenu - Generate SQL

This submenu provides possibility to get a SQL query to manipulate the object:

  • Create – Opens the SQL Editor, with query to create object.
  • Drop – Opens the SQL Editor, with query to drop object.
  • Rename – Opens the SQL Editor, with query to rename object.

Table

Submenu - Generate SQL Table

This submenu provides possibility to get a SQL query to manipulate the table's structure and data:

  • Create – Opens the SQL Editor, with query to create table.
  • Drop – Opens the SQL Editor, with query to drop table.
  • Rename – Opens the SQL Editor, with query to rename table.
  • Select – Opens the SQL Editor, with query to select data from the table.
  • Delete – Opens the SQL Editor, with query to delete data from the table.
  • Insert – Opens the SQL Editor, with query to insert data to the table.
  • Update – Opens the SQL Editor, with query to update data in the table.

Fields Dialog

The Valentina studio provides the special dialog allowed to choose the fields of table for generate queries for SELECT, INSERT and UPDATE records.

Fields Dialog

In result you will get query:

SELECT
	"description",
	"length",
	"rating",
	"title"
FROM "film";