CREATE PROCEDURE Statement (Microsoft Access SQL)
Access Developer Reference |
Creates a stored procedure.
Note |
---|
The Microsoft Access database engine does not support the use of CREATE PROCEDURE, or any of the DDL statements, with non-Microsoft Jet database engine databases. |
Syntax
CREATE PROCEDURE procedure [param1 datatype[, param2 datatype[, …]] AS sqlstatement
The CREATE PROCEDURE statement has these parts:
Part | Description |
---|---|
procedure | A name for the procedure. It must follow standard naming conventions. |
param1, param2 | From one to 255 field names or parameters. For example:
For more information on parameters, see PARAMETERS. |
|
|
datatype | One of the primary Microsoft Access SQL data types or their synonyms. |
sqlstatement | An SQL statement such as SELECT, UPDATE, DELETE, INSERT, CREATE TABLE, DROP TABLE, and so on. |
Remarks
An SQL procedure consists of a PROCEDURE clause that specifies the name of the procedure, an optional list of parameter definitions, and a single SQL statement.
A procedure name cannot be the same as the name of an existing table.
Example
This example names the query CategoryList.
This example calls the EnumFields procedure, which you can find in the SELECT statement example.
|
See Also
ALTER USER or DATABASE Statement