Here's one I used earlier.
CREATE TABLE FeaturedSites (FeaturedSiteID COUNTER,
Link VARCHAR(255),
URL VARCHAR(255),
CONSTRAINT CreatePK PRIMARY KEY (FeaturedSiteID));
This creates a table called FeaturedSites with an Auto number field called
FeaturedSiteID and two text fields (Link and URL), set to 255 characters.
Then it creates a constraint that makes the FeaturedSiteID the primary key.
Where you see "CreatePK", that's just the name of the constraint being
created... ie you can call it whatever you want.
--
Aidan Whitehall <[EMAIL PROTECTED]>
Netshopper UK Ltd
Advanced Web Solutions & Services
http://www.netshopperuk.com/
Telephone +44 (01744) 648650
Fax +44 (01744) 648651
------------------------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message
with 'unsubscribe' in the body to [EMAIL PROTECTED]
