updating an SQL db

Results 1 to 2 of 2

Thread: updating an SQL db

  1. #1
    Join Date
    Dec 1969

    Default updating an SQL db

    I'm renting an SQL bd an want to insert a new colum into an table. How do I do that?

  2. #2
    Join Date
    Dec 1969

    Default RE: updating an SQL db

    The best way is to open the design view of the table on your local pc and edit the table layout. Before you save and close the table design, press the &#039;Save change script&#039; button (usually about third from the left) and save the script or copy it.<BR><BR>Then open query Analyser and connect to your remote DB you are renting, put the script in, and run it. The table should be updated without any errors.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts