Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2003
    Location
    KL, Malaysia
    Posts
    38

    Unanswered: view information

    After a view is created, where would the information of its base table be stored ( i.e. this view is built from which base table)?


    Are there any stored procedures to pull out which tables are used to built the view?

    Thanks.
    Save the dugongs!

  2. #2
    Join Date
    Jul 2003
    Location
    The Dark Planet
    Posts
    1,401
    Try using sp_depends for getting to know the Tables

  3. #3
    Join Date
    Jan 2003
    Location
    KL, Malaysia
    Posts
    38
    Yeap, tried that already. I was looking forward to get information on the individual columns.

    I.e., if the view has an alias, how do I know which column the alias is tied to programmatically?

    I've tried sp_helptext but would be interested to know whether there are other ways to retrieve the information.
    Save the dugongs!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •