Web Wiz - Green Windows Web Hosting
Web Wiz Homepage Search Web Wiz

  New Posts New Posts RSS Feed - How to add fields/tbls remotely?
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

How to add fields/tbls remotely?
 Post Reply Post Reply
Author
  Topic Search Topic Search  Topic Options Topic Options
Necronom View Drop Down
Groupie
Groupie


Joined: 19 October 2001
Location: United States
Status: Offline
Points: 116 		Post Options Post Options   Thanks (0) Thanks(0)   Quote Necronom Quote  Post ReplyReply Direct Link To This Post Topic: How to add fields/tbls remotely?
    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 .
Back to Top
Semikolon View Drop Down
Senior Member
Senior Member


Joined: 09 September 2003
Location: Norway
Status: Offline
Points: 1718 		Post Options Post Options   Thanks (0) Thanks(0)   Quote Semikolon Quote  Post ReplyReply Direct Link To This Post 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
Back to Top
Necronom View Drop Down
Groupie
Groupie


Joined: 19 October 2001
Location: United States
Status: Offline
Points: 116 		Post Options Post Options   Thanks (0) Thanks(0)   Quote Necronom Quote  Post ReplyReply Direct Link To This Post Posted: 07 February 2004 at 4:41pm

Thx!

What are the alter options for editing an existing table?

. necronom .
Back to Top
Mart View Drop Down
Senior Member
Senior Member
Avatar

Joined: 30 November 2002
Status: Offline
Points: 2304 		Post Options Post Options   Thanks (0) Thanks(0)   Quote Mart Quote  Post ReplyReply Direct Link To This Post Posted: 07 February 2004 at 4:46pm
http://www.w3schools.com/sql/sql_alter.asp
Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.08
Copyright ©2001-2026 Web Wiz Ltd.

Become a Fan on Facebook Follow us on X Connect with us on LinkedIn Web Wiz Blogs
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

Copyright ©2001-2026 Web Wiz Ltd. All rights reserved.