Results 1 to 2 of 2

Thread: Deleting table?

  1. #1
    Join Date
    Feb 2003
    Posts
    5

    Unanswered: Deleting table?

    how would i go about deleting at whole table, or just the sql string...

    say i wanted to delete table userName?

    any help would be great thanks

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    to remove all rows, leaving the table in the database but empty:

    DELETE FROM YOURTABLE

    if sql server, and you do not need the rows logged, just want the table emptied:

    TRUNCATE TABLE YOURTABLE

    if you don't want the table no more at all:

    DROP TABLE YOURTABLE


    rudy

Posting Permissions

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