Using SQL

SQL statements can be used to interactively query a database directly from within MicroStation.

All SQL statements recognized by the database software are supported, including:

SELECT	Query database tables.
UPDATE	Edit rows in a table.
DELETE	Delete rows.
INSERT	Add new rows.
CREATE TABLE	Define a new table and add it to the database.
DROP TABLE	Delete an existing table.

Opening and Saving Query Statements

SQL Statements

Specific SQL Window Key-ins

Using the SQL Window

Command Files

Manually Committing SQL Statements

Parent topic: Linking Database Rows to Elements