Problems finding table in sql [closed]

0

When I use o Select * From table_x and I go through my table, SQL does not find the indicated table?

    
asked by anonymous 25.02.2016 / 21:21

2 answers

1

You probably created the table in the context of your user

Make the following verification

//esse é o padrão
Select * from banco.dbo.tabela
//Sua tabela esta assim provavelmente
Select * from banco.seu_usuario.tabela
    
26.02.2016 / 03:16
0

Try to pass on the name of the database, too, it would look something like this:

SELECT * FROM seu_banco.minha_tabela;

The times I had related issues, I used it that way and it worked!

    
25.02.2016 / 21:51