Table Creation with Default Values 1

[sujitopics]

hai
how to create a table in database thru query analyzer.
i have a default value for the field.
for ex.

create table emp (eno int);

for the above table how can i set the default value for eno field.

can anybody know this..please give me the sql query to create table with default values

Thanks in advance
Yours
Suji

 

[jitter]

Something like:


create table emp
(eno int Default ('ValueHere'));


Check Create Table in BOL for more information and examples.