[RESOLVED] Create Tables

[Jagjit]

Hi

In the Below code tables are created in Master , whereas tables should be created in MyDatabase.

Dim str As String
Dim sql As String
Dim str_use As String

str = "CREATE DATABASE MyDatabase ON PRIMARY " & _
"(NAME = MyDatabase_Data, " & _
" FILENAME = 'E:\T01-02.mdf', " & _
" SIZE = 2MB, " & _
" MAXSIZE = 10MB, " & _
" FILEGROWTH = 10%) " & _
" LOG ON " & _
"(NAME = MyDatabase_Log, " & _
" FILENAME = 'E:\T01-02.ldf', " & _
" SIZE = 1MB, " & _
" MAXSIZE = 5MB, " & _
" FILEGROWTH = 10%) "
conFind.Execute (str)

str_use = "Use MyDatabase"
conFind.Execute (str_use)

sql = "Create table VType(" & _
"[vtype] [nvarchar](20)" & _
"Primary Key([VType]))"
conFind.Execute (sql)

Thanks

[si_the_geek]

Thread moved to the 'Database Development' forum - which is where you should always post Database/SQL specific questions (while Databases and SQL can be used in VB, they are certainly not specific to VB)

[jggtz]

Try

sql = "Create table MyDatabase.VType(" & _
       "[vtype] [nvarchar](20)" & _
       "Primary Key([VType]))"
conFind.Execute (sql)

[Jagjit]

Hi

It is giving error "Specified Schema does not exists or you don't have permission to use it ".
MyDatabase exists

Thanks

[jggtz]

In my case I use dbo as schema, try : MyDatabase.dbo.VType

[techgnome]

dbo is the "DataBaseOwner" ... not the schema... the full format is Schema.Owner.Object... at any rate... the reason it didn't work originally was because it was using the original connection which was tied to the master database... once the database is created, close the connection, and re-open it, this time using the new database as the schema... then your create tables will work as expected.

-tg