You can use statements in Structured Query Language (SQL statements) to define, display, add, change and delete data in the database.
Property |
More information |
---|---|
Schema |
SQL Tutorial, Schemas SQL Reference Manual, CREATE SCHEMA Statement (create_schema_statement) |
Foreign Keys (referential integrity) |
SQL Tutorial, Foreign Key Dependencies Between Tables SQL Reference Manual, Referential CONSTRAINT Definition (referential_constraint_definition) |
Explicit and implicit locks on rows, tables and the database catalog |
SQL Reference Manual, Transactions |
Updatable view table |
SQL Tutorial, View Tables SQL Reference Manual, CREATE VIEW Statement (create_view_statement) |
Temporary table |
SQL Reference Manual, CREATE TABLE Statement (create_table_statement) |
Domain definition |
SQL Tutorial, Domains SQL Reference Manual, CREATE DOMAIN Statement (create_domain_statement) |
Join |
SQL Tutorial, Joins: Information From Several Tables SQL Reference Manual, JOIN Predicate (join_predicate) |
Subquery |
SQL Tutorial, Subquery: Inner Queries SQL Reference Manual, Subquery (subquery) |
Subtransaction |
SQL Reference Manual, SUBTRANS Statement (subtrans_statement) |
Number generator (auto-increment column) |
SQL Tutorial, Number Generators for Tables SQL Reference Manual, CREATE SEQUENCE Statement (create_sequence_statement) |
Database procedure (stored procedures) |
SQL Tutorial, Database Procedures SQL Reference Manual, CREATE DBPROC[EDURE] Statement (create_dbproc_statement) |
Database function (user-defined function) |
SQL Tutorial, Database Functions SQL Reference Manual, CREATE FUNCTION Statement (create_function_statement) |
Triggers |
SQL Tutorial, Database Triggers SQL Reference Manual, CREATE TRIGGER Statement (create_trigger_statement) CREATE SYSTEM TRIGGER Statement (create_system_trigger_statement) |
Server-side cursor |
SQL Reference Manual, DECLARE CURSOR Statement (declare_cursor_statement) |
Shared SQL (re-use of execution plans) |
Special Database Parameters UseSharedSQL |
Optimization |
Concepts of the Database System, SQL
Database Studio, Working with SQL Statements: Overview