DDL

Tue, 28 Nov 2006 16:39:21 GMT

clipped by: aveeshkumar

   CREATE TABLE TestAllTypes
   (

      MyText       TEXT(50),
      MyMemo       MEMO,
      MyByte       BYTE,
      MyInteger    INTEGER,
      MyLong       LONG,
      MyAutoNumber COUNTER,
      MySingle     SINGLE,
      MyDouble     DOUBLE,
      MyCurrency   CURRENCY,
      MyReplicaID  GUID,
      MyDateTime   DATETIME,
      MyYesNo      YESNO,
      MyOleObject  LONGBINARY,
      MyBinary     BINARY(50)
    )

   CREATE TABLE TestPrimaryKey
   (
      MyID LONG CONSTRAINT PK_MyID PRIMARY KEY,
      FirstName TEXT(20),
      LastName  TEXT(20)
   )

Tags: access, ddl, alter table

Clipmarks | aveeshkumar's clips

DDL