creata a table at run time

[Jacobs]

hi,

i need to create a sql server table from an application.
There are two fields(ID , NAME) for table called 'VIEWDATA'. id field is auto number.
please show me create table statement for this.


thanks

[net guru]

You should be able to do this. something like.

Create table VIEWDATA(ID Int not null IDENTITY Primary key,
NAME varchar(55));


i havent tested this but you can play around with this and get it working.
_________________
Thanks

NET GURU