Forums

ASP

This topic is locked

Create Table

Posted 07 Jan 2002 18:48:08
1
has voted
07 Jan 2002 18:48:08 Aaron White posted:
How do you create a new table in SQL Server 2000 from an asp page if you are using an OLE DB connection method?

Replies

Replied 08 Jan 2002 07:39:24
08 Jan 2002 07:39:24 Joel Martinez replied:
in theory, you should be able to pass in a sql string that looks something like this:<pre id=code><font face=courier size=2 id=code>CREATE TABLE thetable (ID int NOT NULL Primary Key, FieldName VarChar(10))</font id=code></pre id=code>This is obviously a really simple table, check out www.sqlteam.com if you have any sql questions... great site

Joel Martinez [ ]
----------
E-Commerce Concepts with Ultradev...pre-order yours at
www.basic-ultradev.com/ecomm_concepts/

Reply to this topic