I am trying to create a new table in my database using the CREATE of SQL however i am having a problem.
If I choose to INSERT i do:
SQLINSERT = " INSERT INTO UserDefined (Titled, Definition)
VALUES("
SQLINSERT = SQLINSERT & " '" & title & "' , "
SQLINSERT = SQLINSERT & " '" & it & "' )"
set conn = server.createobject("ADODB.Connection")
conn.open "UML"
set add=conn.execute(SQLINSERT)
conn.close
How do I construct the CREATE??
This is what I want to do:
CREATE TABLE UserTable (item char(30))
Which creates a new table in my database with 1 field heading of "item". Is the above line done correctly???
Also what goes after it? like in INSERT i do:
set conn = server.createobject("ADODB.Connection")
conn.open "UML"
set add=conn.execute(SQLINSERT)
conn.close
Help would be much appreciated