sql - Access: create table if it does not exist

Question

Can you give an MS Access equivalent to MySQL 'CREATE TABLE IF NOT EXISTS ...'?

Update

Something like this

IF <no such table>
CREATE TABLE history(<fields>)

would be suitable as well

Answer 1

For SQL DDL code the answer is no. ACE/Jet SQL does not have any control-of-flow syntax and a ACE/Jet PROCEDURE can only execute one SQL statement. Yes, that's right: an ACE/Jet PROCEDURE does not support procedural code :(