documentation.HELP! Microsoft Jet SQL Reference Documentation

Microsoft Jet SQL Reference

Microsoft Jet SQL Reference

Table of contents

• Microsoft Jet SQL Reference
  • Overview
    • SQL Aggregate Functions
    • SQL Expressions
    • SQL Reserved Words
    • SQL Data Types
    • ODBC Scalar Functions
    • Comparison of Microsoft Jet SQL and ANSI SQL
    • Equivalent ANSI SQL Data Types
    • Wildcard Characters in String Comparisons
  • Data Definition Language
    • CREATE TABLE Statement
    • CREATE INDEX Statement
    • CREATE PROCEDURE Statement
    • CREATE USER or GROUP Statement
    • CREATE VIEW Statement
    • ADD USER Statement
    • DROP USER or GROUP Statement
    • ALTER TABLE Statement
    • ALTER USER or DATABASE Statement
    • CONSTRAINT Clause
    • DROP Statement
    • GRANT Statement
    • REVOKE Statement
  • Data Manipulation Language
    • SELECT Statement
    • SELECT...INTO Statement
    • INSERT INTO Statement
    • UPDATE Statement
    • DELETE Statement
    • EXECUTE Statement
    • TRANSACTION Statement
    • TRANSFORM Statement
    • INNER JOIN Operation
    • LEFT JOIN, RIGHT JOIN Operations
    • UNION Operation
    • PARAMETERS Declaration
    • WITH OWNERACCESS OPTION Declaration
    • PROCEDURE Clause
    • SQL Subqueries
  • Windows Registry Settings for External Data Sources
    • Customizing Windows Registry Settings for Microsoft Jet
    • Initializing the dBASE Database Driver
    • Initializing the Lotus Driver
    • Initializing the Microsoft Excel Driver
    • Initializing the Microsoft Exchange Data Source Driver
    • Initializing the Microsoft Jet 4.0 Database Engine Driver
    • Initializing the Microsoft Jet 3.5 Database Engine Driver
    • Initializing the Microsoft Jet 2.5 Database Engine Driver
    • Initializing the Paradox Database Driver
    • Initializing the Text and HTML Data Source Driver
    • Configuring the Microsoft Jet Database Engine for ODBC Access
  • What's New
    • Overview of What's New
    • What's New with Data Definition Language
    • What's New with Data Manipulation Language
    • What's New with Windows Registy Settings

next page

Get in touch

Submit feedback about this site to:

• [email protected]