Saturday, September 10, 2011

CREATE TABLE in Access Database

This script creates a table tblCategory with ID is primary key and auto number,  CategoryName  VARCHAR(255)

CREATE TABLE [tblCategory] (
    [ID] AUTOINCREMENT,
    [CategoryName] TEXT(255),
    [ParentID] LONG,
    [GroupID] LONG,
    CONSTRAINT [PrimaryKey] PRIMARY KEY ([ID])
);

No comments:

Post a Comment

Oracle Query