Need Help with Create Table in SQL Server

  • From: "Ray Campbell" <ray.campbell@xxxxxxxxxxxxxxxxxxxxx>
  • To: <programmingblind@xxxxxxxxxxxxx>
  • Date: Fri, 26 Oct 2007 11:22:52 -0500

Hello All:

I'm running into a problem creating a table in SQL server, ans ad far as
I can tell from what I've read I'm doing everything correctly.  My
command is:

CREATE TABLE customer
(customer_number int not null, customer_name varchar(25) not null,
customer_address varchar(25) not null, customer_city varchar(20) not
null, customer_state char(2) not null, customer_zip varchar(10) not
null)
PRIMARY KEY (customer_number);

When I run this in the Query Analyzer of SQL Server 2000 on an existing
database, I get a syntax error and the table doesn't get created.  I've
looked at various SQL references on google and this seems to be the
correct syntax.  What am I doing wrong?

Thanks for any help.


Ray Campbell, Help Desk Technician
Adaptive Technology Center
Chicago Lighthouse for People Who Are Blind or Visually Impaired
1850 W. Roosevelt Road
Chicago, IL  60608
312-997-3651 (Voice/Relay) or
888-825-0080 (voice/Relay)
ray.campbell@xxxxxxxxxxxxxxxxxxxxx 
AIM Screen Name: tclhelp
__________
View the list's information and change your settings at
//www.freelists.org/list/programmingblind

Other related posts:

  • » Need Help with Create Table in SQL Server