Silverstone
Programmer
I'm looking to get column information back for multiple views within the same database, rather than having to go back to numerous databases to find the source tables.
I want to automate the process so that it will look at all views within the DBC.Tables view, for the database i specify.
I know i can use the HELP COLUMN statement but it doesn't seem to like a subquery and plus i need to create an output table to store the results in.
Any ideas?
I want to automate the process so that it will look at all views within the DBC.Tables view, for the database i specify.
I know i can use the HELP COLUMN statement but it doesn't seem to like a subquery and plus i need to create an output table to store the results in.
Any ideas?