create table using sql (will implement using asp)

[hallm]

I've created a table using Microsoft access that I want to add to my online database (I just can't download and upload it every time I add a table).&nbsp;&nbsp;I was told that I could add this table using sql with an asp page.&nbsp;&nbsp;What would be the sql statement to create the following table?<br><br>Table name&nbsp;&nbsp;login<br><br>Fields<br><br>loginID&nbsp;&nbsp;&nbsp;&nbsp;autonumber&nbsp;&nbsp;&nbsp;&nbsp;indexed (no duplicates)<br>name&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;text&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;fieldsize&nbsp;&nbsp;&nbsp;50<br>level&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;text&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;fieldsize&nbsp;&nbsp;&nbsp;50<br>username&nbsp;&nbsp;&nbsp;text&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;fieldsize&nbsp;&nbsp;&nbsp;50<br>password&nbsp;&nbsp;&nbsp;text&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;fieldsize&nbsp;&nbsp;&nbsp;50<br>

 

[KMITCH]

CREATE TABLE login(loginID COUNTER CONSTRAINT PriKey PRIMARY KEY , name TEXT(50),level TEXT(50) , username TEXT(50) , password TEXT(50) ) ;

Just paste the above SQL into the SQL window
of a new query. I took the liberty of making
loginID the primary key. When you save it, it
will have a new symbol, indicating that it is a
Data Definition query.

You may want to check out the link below for some
naming conventions that will make your life easier.

http://msdn.microsoft.com/LIBRARY/BACKGRND/HTML/MSDN_20NAMING.HTM

Hope this helps.

Keith