Classic ASP Discussion - How to add fields/tbls remotely?

Print Page | Close Window

How to add fields/tbls remotely?

Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Classic ASP Discussion
Forum Description: Discussion on Active Server Pages (Classic ASP).
URL: https://forums.webwiz.net/forum_posts.asp?TID=9591
Printed Date: 31 March 2026 at 11:22pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: How to add fields/tbls remotely?

Posted By: Necronom
Subject: How to add fields/tbls remotely?
Date Posted: 06 February 2004 at 2:33pm

I've seen a bunch of FAQ's on how to create a blank nameless table to a db remotely via ASP, but what I'm looking to do is create just a field in a table that alread exists via ASP. Doesn anyone know how to do this?

Does anyone know of a remote DB editor that's all ASP? If there isn't one, I think that'd be a great idea.

thx!

. necronom .

Replies:

Posted By: Semikolon
Date Posted: 06 February 2004 at 3:35pm

Some SQL statements:

Create Table: CREATE TABLE tablename (fields)

Delete Table: DROP TABLE tablename [Drop options]

Edit Table: ALTER TABLE table alter options

Posted By: Necronom
Date Posted: 07 February 2004 at 4:41pm

Thx!

What are the alter options for editing an existing table?

. necronom .

Posted By: Mart
Date Posted: 07 February 2004 at 4:46pm

http://www.w3schools.com/sql/sql_alter.asp - http://www.w3schools.com/sql/sql_alter.asp