Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: SmileyConspiracy
- Content: Threads
- Order by date
-
Creating a list of column names output by a view
I need to Create a list of column names output by a view. Not a problem using sysobjects and syscolumns. The problem is that I also need to get the tablename for where each column comes from. i.e. if I had the following as a view Select Person.DomicileId, Person.PersonId from Person Inner Join...- SmileyConspiracy
- Thread
- Replies: 0
- Forum: Microsoft SQL Server: Programming
