• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 247
  • Last Modified:

SQL Server how to find a table and generate the script for it.

I have view based on table. Which I can not find in Enterprise Manager.
Is there such a thing as hidden table in SQL Server?
How can I find it... Once I find it - how can I script a single table?
0
JElster
Asked:
JElster
  • 2
1 Solution
 
wdosanjosCommented:
Check on the views below for your table:

select * from INFORMATION_SCHEMA.TABLES
select * from INFORMATION_SCHEMA.VIEWS

0
 
JElsterAuthor Commented:
I don't see it but one of the views is based on it.. How is this possible
0
 
JElsterAuthor Commented:
I found it .. it's a user defined function.. but I don't have rights to view it
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now