Results 1 to 2 of 2

Thread: Fields...

  1. #1
    Join Date
    Oct 2003
    Posts
    1

    Smile Unanswered: Fields...

    How do you delete/remove a certain field in a table?

    I want to remove a certain field on which i added recently....unfortunately, i'm having a hard time removing/deleting it.

    with sql7/2000 it's easy but with 6.5, there's no function or i just dont know how....


    thanks in advance...

  2. #2
    Join Date
    Oct 2003
    Location
    Pune, India
    Posts
    14
    You cannot amend SQL 6.5 columns by using the ALTER TABLE statement as in SQL Server 7.0/2000 you can.
    You should create another table with the appropriate structure, copy data from the old table into the new one, and delete the old table.
    Thanks & Regards,
    Dipayan Sarkar
    (dipayan@covisible.com)
    (CoVisible Solutions - A Knowledge Management Software company)

Posting Permissions

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