Contact | Privacy | Datenschutzerklärung | Impressum

Altering SQL Tables

SQL users know they can ADD or DROP fields from an SQL TABLE by using the ALTER TABLE command. Here are examples of how the same operations would be performed using dbupdate:

To ADD a field: To Drop a field:
<dbupdate>
  ALTER TABLE guestbook
   ADD Password CHAR(8) 
</dbupdate>
<dbupdate>
  ALTER TABLE guestbook
    DROP Password 
<dbupdate>


This page was dynamically generated by the web application development tool RADpage of H.E.I. H.E.I. provides support, tools, and services like Webdesign in Mannheimm, the HTML/CSS 3D WebGL Animation Library taccgl, 3D Webdesign, and 3D Product Configurator (3D Produkt Konfigurator in German).

Selected blog articles : 3D Objects on HTML pages, CSS Transition Visibility, and CSS Transition Display.


© 1996-2024 H.E.I. All Rights Reserved.



Homepage
Intro/Features
Component Guide
Programming
  Language Guide
    Modular Pages
    Dynamic Pages
    Interactive Pages
      Creating FORMs
      Session Mode
      Search FORMs
      Scrolling Pages
      Email FORMs
      SQL Intro
        Defining Tables
          Create
          Alter
          Drop
        Updating Tables
        Querying Tables
  Language Ref.
  Component Ref.
  Class Library
  User Components
  Tutorial
  New Features
  heitml 1
User Guide
Services
Privacy
Datenschutz
 
Contact / Impressum