Issue Details (XML | Word | Printable)

Key: CORE-831
Type: Improvement Improvement
Status: Closed Closed
Resolution: Fixed
Priority: Minor Minor
Assignee: Dmitry Yemanov
Reporter: Valdir Stiebe Junior
Votes: 0
Watchers: 1
Operations

If you were logged in you would be able to see more operations.
Firebird Core

CREATE VIEW as SELECT ....

Created: 27/Jun/06 03:35 AM   Updated: 07/Apr/08 11:25 AM
Component/s: Engine
Affects Version/s: 2.0 RC2
Fix Version/s: 2.1 Alpha 1

Time Tracking:
Not Specified

Issue Links:
Duplicate
 
Relate
 


 Description  « Hide
When creating a view, it would be easier if we could use the following syntax:

create view V_NAME as
  select
    T1.FIELD1,
    T1.FIELD1 COLUMN_ALIAS1,
    T1.FIELD1 COLUMN_ALIAS2
  from
    TABLE1 T1

instead of

create view V_NAME (FIELD1, COLUMN_ALIAS1, COLUMN_ALIAS2) as
  select ...

Since a select command can't repeat a column alias, this field list could be optional.
And it will be much easier to store view definitions on some database modelling tools.

 All   Comments   Work Log   Change History   Version Control   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
Philippe Makowski added a comment - 07/Apr/08 11:25 AM
Q/A tested