May 9, 2003 at 10:21 am
How do you print specification on Views
showing the fields and links to other Views?
May 9, 2003 at 10:49 am
The system stored procedure sp_helptext will give you the view definition. Is that what you're needing?
K. Brian Kelley
http://www.truthsolutions.com/
Author: Start to Finish Guide to SQL Server Performance Monitoring
http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1
K. Brian Kelley
@kbriankelley
May 9, 2003 at 1:15 pm
How do you execute the SP Helptext ?
I would like to draw diagrams under the database name but it only allows you to do fields and sizes,and diagrams for Tables .
May 9, 2003 at 1:29 pm
To execute write:
EXEC sp_Helptext view_name from Query Analizer. But this won't show you the relations like the diagram does. If will only show you the tsql code used to create the view.
You will be able to check the columns, the tables it references...but all in code.
May 9, 2003 at 1:44 pm
Thanks !
Why do you think they setup diagrams for
tables only ?
Maybe I am doing things the wrong way - I use
Views to link with other views to create final data view for Reporting.
May 9, 2003 at 1:56 pm
Maybe you should used joins between tables when posibble. But you should check wich is the best choice.
May 9, 2003 at 2:03 pm
I am loading a large file that I select
records in a veiw then I match with other Views - sometimes linking up to 20 Views -
Can anyone recomend a better way ?
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply