[fretel]

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

[r937]

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