Try:
Create Table ForumID
(ForumID integer not NULL IDENTITY (1,1) PRIMARY KEY CLUSTERED, CategoryID
integer DEFAULT 0)
Bob
-----Original Message-----
From: S R [mailto:[EMAIL PROTECTED]]
Sent: May 8, 2001 2:35 PM
To: CF-Talk
Subject: SQL Code problem
Hi,
I'm trying to create a table and set a 'default value' for one of the
columns using the SQL Query analyzer. I keep getting this error when I try
to run the script:
Server: Msg 128, Level 15, State 1, Line 3
The name 'CategoryID_default' is not permitted in this context. Only
constants, expressions, or variables allowed here. Column names are not
permitted.
I can't seem to find anything wrong. I'm using MS SQL Server 2000
Here's my code:
Create Table ForumID
(ForumID integer not NULL IDENTITY (1,1) PRIMARY KEY CLUSTERED, CategoryID
integer,
DEFAULT CategoryID_default '0' FOR CategoryID)
any help is appreciated,
Thank you
Sal
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
