[RESOLVED] Creating a table (ifnotexists) at startup of my vb.net app [vb.net]

[Devdude]

Hi,

I am trying to find out the way on how to create a table at the startup when running my app ...

This should only happen if the table does not yet exists.

I have looked into tsql and stored procedures.

I understand that I will have to add a file to my project in the solution explorer ...

I understand that it will look similar to :

CREATE TABLE tblName ( [UID] int, [Name] varchar(64), [Address] varchar(255) )


What i dont understand is ...

1) Which item should i add to my project ... ive seen various things been used but am not sure whats correct? .sql? .txt? ...

2) How would I find out whether the table exists or not?

3) How do I run this file?


I hope someone can enlighten me ...

Many thanks in advance,

Rob

I am using VS2005.