auto number primary key - restarting

Hi, is there an SQL command for making a primary key (auto number key) to start numbering from beginning after deleting all the records from the table. thanks

how to 'tell' the select what to omit

Hallo suppose you have a table with great number of columns (20 or 30), and you would like to specify every one but two or tree columns in a SELECT statement. Is there a way to specify only those two or tree columns for omission (which would be the 'short' way to do the job) instead of specifyin

autonumber rows in SQL result, how to

- how to autonumber rows in SQL result I would like to put an auto numbering column in any SQL SELECT result, is it possibile? miroslav i.