It doesn't look right to me (unless this is "pseudo code").. You can use
pretty much any regular SQL statement within CFQUERY.
I would use Enterprise Manager to create a SQL Script to create the table
-- easiest way I've found to do it. The only thing you will have to remove
from it is the TSQL "GO" statements. You will also find that not all TSQL
will work in one CFQUERY block, so you may need to split them up.
Here's an example from SQL Books online:
CREATE TABLE publishers
(
pub_id char(4) NOT NULL
CONSTRAINT UPKCL_pubind PRIMARY KEY CLUSTERED
pub_name varchar(40) NULL,
city varchar(20) NULL,
state char(2) NULL,
country varchar(30) NULL
DEFAULT('USA')
)
I'd really recommend SQL books online, as it has a plethora of
information.
Darryl
---
You are currently subscribed to cfaussie as: [email protected]
To unsubscribe send a blank email to [EMAIL PROTECTED]
Aussie Macromedia Developers: http://lists.daemon.com.au/
