My suggestion is to write a stored procedure using the t-sql create table
command. You'll have a lot of power to customize it exactly as you wish.
it could be as simple as this:
-- begin code
CREATE PROCEDURE [dbo].[usp_create_table]
@table_name varchar(100) ,
@body varchar(7800)
AS
declare @sql_begin varchar(100)
declare @sql_middle varchar(100)
declare @sql_end varchar(100)
set @sql_begin = 'CREATE TABLE dbo.'
set @sql_middle = '('
set @sql_end = ')'
execute(@sql_begin + @table_name + @sql_middle + @body + @sql_end)
GO
-- end code
@table_name is the name of the table.
@body are the parameters of the create table command.
If you're not familiar with create table, check out Books Online in Query
analyzer.
-----Original Message-----
From: Vishal Narayan [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 23, 2002 7:05 AM
To: CF-Talk
Subject: Need SQL Server version of createtable_Access
I found on the Allaire Developer's Exchange a custom tag called
createtable_Access, which allows me to create a table in any MS Access ODBC
datasource accessible through ColdFusion, in which we can define Primary
Key, Required fields (Not Null), and Unique values.
What I need is a SQL Server version of this tag. Does anyone know if such a
tag is available ? I need to be able to create new tables through a
web-based interface on my SQL 2000 DB.
Vishal.
______________________________________________________________________
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
