Common Tasks

This section gives step-by-step instructions to perform some of the more frequently performed tasks in SQLEditor.

• Create a new document

• Add a table

• Add a field to a table

• Create a foreign key relation

• Create a table level Foreign Key

• Create a multi-column Index

• Create a Check Constraint on a table

• Create a View

• Add a document comment to the document

• Export to SQL DDL Schema Text File

• Export selected objects

• Change export SQL dialect

• Import SQL database description from a text file

• Set the default SQL dialect for new documents