[SQL] AUTO INCREMENT

[GANESH KUMAR]

i am searching for 
autoincrement in table 

in table employee
i want give empno as autoincrement

is there any syntax
like this
 create table emp
(empno  integer auto_increment);

send reply
ganesh

__________________________________________________
Do You Yahoo!?
Yahoo! Photos -- now, 100 FREE prints!
http://photos.yahoo.com