How do I solve this kind of error please

Question

1.00/5 (2 votes)

See more:

create table customer_Name(

Fname        varchar(20),
Minit        varchar(20),
Lname        varchar(20),
Customer_id    int,
constraint customer_name_pk
primary key (Customer_id),

);

Msg 1801, Level 16, State 3, Line 1
Database 'clothingstore' already exists. Choose a different database name.
Msg 2714, Level 16, State 6, Line 2
There is already an object named 'customer' in the database.

What I have tried:

NOte the table has run before but when I try to run it again this message appears

Posted 1-Dec-22 23:59pm

Noran Azab

Updated 2-Dec-22 0:28am

Add a Solution

Comments

Chris Copeland 2-Dec-22 6:12am

So you've already created the table and you're trying to create it again? Why? Once you've created the table you can either alter it using alter table commands, or drop it completely using drop table commands (though this will erase all the data in the table)

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Answer 1 · 2022-12-02T00:28:00

If a database exists on a particular server, you cannot create a new DB of the same name without deleting the existing one first - if you try, you get the first error.

The second error is exactly the same, but for the table of the same name.

Databases are designed to be persistent: they hold information even when your app is not running. If you app tries to create the DB and it's tables each time it starts, that persistence would go away, and the data would not be carried forward into you app each time it ran.