Information générale
Forum:
Microsoft SQL Server
Catégorie:
Stored procedures, Triggers, UDFs
Titre:
Views - Underlying columns in Views (What Table?)
SQL SERVER 7.0
Im having a problem determining the underlying tables from a view using Sql Statements.
Create 2 tables having Employee_no in both tables.
Create a view linking these two tables on the Employee_no columns.
Select only the Employee_no column from Table 2 as output in the view.
Here is where my problem starts.
Using Sysdepends, SysColumns, SP_help , SP_depends - I am unable to determine what table the Employee_no output field is coming from.
Syscolumns showing the underlying tables and the colid from the underlying tables would solve my problem.
PLEASE HELP!
I need this information to pass to the front end to build the cursor properties of the result set(s).
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement