on 02-10-2016 1:23 PM
I have to create a lot of views with a lot of tables.
When I join a view to a table, I seem to have to enter all the columns manually.
Is there a way to automatically select every column from the table so I can then remove the few I don't need ?
Thanks
Mike
Define a reference/view reference between the objects and double-check the join columns for the reference, then use shift+select to select the objects (connected Tables and/or Views) and 'Tools->Create View'.
This should add all columns from the selected objects into the view.
Once the view is created, open it up its properties and at the bottom of the 'SQL Query' tab there is a button that can show the query properties. Select that button and the query properties open. From there you can edit the SQL directly or on the other tabs, edit the column lists and aliases, expressions, and the join clauses, etc.
Chris
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Select the tables you want to include in the View, then go to the Tools menu and select 'Create View' (this is from memory, so the words might differ a tad)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
10 | |
10 | |
10 | |
7 | |
6 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.