[RESOLVED] Create Tables

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

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)

Try

Code:

---

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

---

Hi

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

Thanks

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

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