Home | Previous Page | Next Page   Basics of Database Design and Implementation > Planning a Database >

Using ANSI-Compliant Databases

You create an ANSI-compliant database when you use the MODE ANSI keywords in the CREATE DATABASE statement. However, creating an ANSI-compliant database does not ensure that this database remains ANSI-compliant. If you take a non-ANSI action (such as CREATE INDEX) on an ANSI database, you will receive a warning, but the application program does not forbid the action.

You might want to create an ANSI-compliant database for the following reasons:

You can use the same SQL statements with both ANSI-compliant databases and non-ANSI-compliant databases.

Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]