Create and use database using t-sql in visual studio

Question

I'm trying to write a single sql script that creates a database, selects it, and then creates the tables for the database but I'm having trouble making this work in visual studio. This is what I'm trying:

create database db_name;

use db_name;
go

create table table_name (
...
);

This gives me an error message "Database db_name does not exist" and in fact this script doesn't create the database. However, if I do not try to use it ie.

create database db_name;
create table table_name (
...
);

I get an error saying "There is already an object named 'table_name' in the database, but it doesn't create the table at all. I'm assuming for whatever reason it's targeting another old database that I have. I don't know how to specify which database to create the table for using the second method and I'm not having any luck selecting the newly created database using the first method.

Put the GO after the Create database. Also, in the second example, you probably have table_name created in the Master database and you don't USE db_name before the Create Table statement. — SS_DBA
– SS_DBA, Commented Nov 9, 2017 at 22:59
i was use db_name before create table but the go statement after create database fixed my issue thanks! — Jessie Cryer
– Jessie Cryer, Commented Nov 9, 2017 at 23:06

Zulander · Accepted Answer · 2017-11-09 22:45:44Z

2

Why don't you use

USE MASTER
GO
DROP DATABASE IF EXISTS db_name

before creating db ?

answered Nov 9, 2017 at 22:45

Zulander

8341 gold badge13 silver badges26 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Jessie Cryer Over a year ago

There is already an object named 'table_name' in the database.

Zulander Over a year ago

DROP TABLE IF EXISTS table_name

Zulander Over a year ago

Perhaps the connection string is not using the right db ?

Collectives™ on Stack Overflow

Create and use database using t-sql in visual studio

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related