SQL Server Management Studio won't recognize a tables

Question

This happens frequently to me, SQL Server doesn't recognize my tables.

I tried to refresh the database, also tried to refresh the intellisense. But nothing worked!

Could anyone help please?

And what is the [current database](https://technet.microsoft.com/en-us/library/ms180770(v=sql.105).aspx#Anchor_2) for that tab? — GSerg, Oct 21 '17 at 20:00
No, you most certainly have [other databases](https://learn.microsoft.com/en-us/sql/relational-databases/databases/system-databases) as well. — GSerg, Oct 21 '17 at 20:03
Oh, Thank you. i have to select the database before creating a query. — Mustafa Alsuhaibi, Oct 21 '17 at 20:03
Can you ensure that you are not running this against the "master" database? When setting up a user, if a default database is not specified, when you connect using SSMS it defaults to master.. change the db or use the use[your database] statement before you run any other queries. — Harry, Oct 21 '17 at 20:10
Could you write `USE Sales_DB` above your select query and try again? — Serkan Arslan, Oct 21 '17 at 20:12
Yes this was my problem, I didn't know that I have to specify the database first. Thank you @Harry — Mustafa Alsuhaibi, Oct 21 '17 at 20:14

score 3 · Answer 1 · answered Oct 23 '17 at 03:16

3

You can preface the code with

USE Sales_DB

And it will always start with that database.

answered Oct 23 '17 at 03:16

Zorkolot

1,899
1
11
8

score 2 · Accepted Answer · answered Oct 21 '17 at 20:15

Can you ensure that you are not running this against the "master" database? When setting up a user, if a default database is not specified, when you connect using SSMS it defaults to master.. change the db or use the use[your database] statement before you run any other queries.

SQL Server Management Studio won't recognize a tables

2 Answers2