> 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.
Here's an example from Books Online:
CREATE TABLE employee
(
emp_id INTEGER
CONSTRAINT p1_constraint PRIMARY KEY NONCLUSTERED,
fname CHAR(20) NOT NULL,
minitial CHAR(1) NULL,
lname VARCHAR(30) NOT NULL,
job_id SMALLINT NOT NULL
DEFAULT 1
REFERENCES jobs(job_id) NOT FOR REPLICATION
)
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444
------------------------------------------------------------------------------
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.