You can use normal cfquery:
<cfquery name="test" datasource="your_dtsource">
create table test1 (testid int null)
</cfquery>
<cfquery name="test" datasource="vhd">
alter table test1 add test2 varchar (30) null
</cfquery>
This shoud work in TSQL.
Check your database manual if you use a different on.
Marius Milosav
Virtual Help Desk Demo (VHD)
www.scorpiosoft.com/vhd/login.cfm
----- Original Message -----
From: Miriam Hirschman <[EMAIL PROTECTED]>
To: CF Forum <[EMAIL PROTECTED]>
Sent: Thursday, April 13, 2000 12:09 PM
Subject: Changing Field Name in an Access DB
Is there a way to change the properties of a field in a table or add a field
to a table through CF?
Thanks,
---miriam
----------------------------------------------------------------------------
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=sts&body=sts/cf_talk or send
a message to [EMAIL PROTECTED] with 'unsubscribe' in the
body.
------------------------------------------------------------------------------
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.
