Solved

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

Posted on 2011-02-27
3
233 Views
Last Modified: 2012-05-11
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
Comment
Question by:JElster
  • 2
3 Comments
 
LVL 23

Accepted Solution

by:
wdosanjos earned 400 total points
Comment Utility
Check on the views below for your table:

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

0
 
LVL 1

Author Comment

by:JElster
Comment Utility
I don't see it but one of the views is based on it.. How is this possible
0
 
LVL 1

Author Comment

by:JElster
Comment Utility
I found it .. it's a user defined function.. but I don't have rights to view it
0

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Join & Write a Comment

Suggested Solutions

This is basically a blog post I wrote recently. I've found that SARGability is poorly understood, and since many people don't read blogs, I figured I'd post it here as an article. SARGable is an adjective in SQL that means that an item can be fou…
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.
You have products, that come in variants and want to set different prices for them? Watch this micro tutorial that describes how to configure prices for Magento super attributes. Assigning simple products to configurable: We assigned simple products…

771 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now