I am creating a UI front end for our users to create databases, complete with tables and indexes, for their clients. After I open the connection, I create my database. If I dont close down the connection, when I create my table, do I have to qualify it with the database name. Or, will the program know where to create the table at?
ADO: qualify table name if open connection
- Thread starter jspeirer
- Start date
Derek Stone
Exalted One
Working with multiple databases usually means executing the USE directive:
Keep in mind that proper security should be in place so one user cannot access another users database.
Code:
USE databasename
CREATE TABLE tablename ...Keep in mind that proper security should be in place so one user cannot access another users database.