Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Fateme
Starting Member
13 Posts |
 Posted - 2010-07-27 : 19:47:03
|
| Hi everyone,I have a database with a lot of tables, quarys, views and storedprocedures.I am looking for a table that I cannot see it's name in table list under database, but I can select data from that table.As I know,I cannot select data from a deleted table,but I am not sure what happend for that tableI'll appreciate for any help.Regards,Fateme |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
Fateme
Starting Member
13 Posts |
Posted - 2010-07-27 : 20:15:19
|
| Thanks Tara for your reply.I am sure that the database that I am looking for in is correct, but perhaps its owned by different user.Is there any way to see list of all tables that are owned by any user in a database ?Thanks,Fateme |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
Fateme
Starting Member
13 Posts |
Posted - 2010-07-27 : 20:23:44
|
| Thanks a lot.My problem's solved.Regards,Fateme |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
How can I find a table in table list of database?