Re: Create table syntax

On 28 Aug 2001, satish rao wrote:

> Entered below is the SQL create table syntax:
>
> CREATE TABLE lists (
> [listid] [int] IDENTITY (1, 1) NOT NULL ,
> [listname] [varchar] (200) NULL ,
> [listcreator] [varchar] (200) NULL ,
> [listdesc] [text] NULL)

create table lists (
listid serial not null,
listname varchar(200),
listcreator varchar(200),
listdesc text);

(You may want to make listid a primary key as well)