You can use NOT NULL on a single field or within a named CONSTRAINT clause that applies to either a single field or to a multiple-field named CONSTRAINT. You can also use the CREATE INDEX statement to create a primary key or additional indexes on existing tables. If NOT NULL is specified for a field, new records are required to have valid data in that field.Ī CONSTRAINT clause establishes various restrictions on a field, and can be used to establish the primary key. Use the CREATE TABLE statement to define a new table and its fields and field constraints. For more information about how to create this index, see CONSTRAINT clause. For more information about how to create this index, see CONSTRAINT clause.Ī CONSTRAINT clause defining a multiple-field index. The field size in characters (Text and Binary fields only).Ī CONSTRAINT clause defining a single-field index. The name of field or fields to be created in the new table. The CREATE TABLE statement has these parts: SyntaxĬREATE TABLE table ( field1 type ] ]) The Microsoft Access database engine does not support the use of CREATE TABLE, or any of the DDL statements, with non-Microsoft Access database engine databases.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |