Katrina,
Here's a simple little table with an incrementing primary key that
increments by 1 and starts at 1:
CREATE TABLE MyTable(MTID int IDENTITY(1,1),
fname varchar(25),
lname varchar(35),
state char(2),
timeentered datetime,
notes text,
CONSTRAINT pk_mtid PRIMARY KEY(mtid))
Hope this helps.
Sincerely,
Dave Phillips
Founder/CEO
ResumeBlaster.com
a service of
PC Pros, Inc.
[EMAIL PROTECTED]
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 18, 2000 12:31 PM
To: [EMAIL PROTECTED]
Subject: SQL Create Table Statement
I am having major cranial flatulence today and can't remember how to write
a create table statement. I don't have access to SQL server's book's
online othewise I'd look up the syntax there. I'm also not the owner of
the database so I can't use the enterprise manager.
Any help would be appreciated.
TIA,
--Katrina
====================
Katrina Chapman
Consultant
Ameriquest Mortgage
----------------------------------------------------------------------------
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
