Hi, I just deleted a sql server database table and want

Question

Hi, I just deleted a sql server database table and want

to recreate it
and it shows this error

There is already an object named in the database
what should I do ?
(also dropped the database and recreated it and
when I tried to create that table
still shows this error)

0

22.05.2021

9 ответов

3 просмотра

Masoud Автор вопроса

Shafiq Jetha
What’s the source of your backup?

you mean sql script ?

0

22.05.2021

Masoud Автор вопроса

Shafiq Jetha
What’s the source of your backup?

use h5p; drop table cached_assets; create table cached_assets ( cached_id int not null, cached_type varchar(200) not null, path varchar(200) not null, index cached_assets (cached_id, cached_type) );

0

22.05.2021

Shafiq Jetha

Masoud
use h5p; drop table cached_assets; create table ca...

I guess I’m asking what the source of the data is because sometimes SQL Server can think a database exists if a file with the right filename happens to be in the right directory. I’m just trying to make sure that this isn’t the case.

0

22.05.2021

Masoud Автор вопроса

Shafiq Jetha
I guess I’m asking what the source of the data is ...

I don't think so btw I'm using sql server in linux

0

22.05.2021

Sevak

Masoud
I don't think so btw I'm using sql server in linux

Just check the path and see if u have anyfile with the same name or not, he is asking about your source of mdf ldf files, just check the path

0

22.05.2021