On 27/08/2013 15:19, Leyne, Sean wrote: > >>>>>> I think an USING clause would be a great addition: >>>>>> >>>>>> GENERATED BY DEFAULT AS IDENTITY [USING SEQUENCE <name>] >>>>>> >>>>>> What do you think? >>>>> What Sequence (name) would be used if the USING was omitted? >>>>> >>>>> >>>> A generated one, like now and like happens with constraints and indexes. >>> Aren't IDENTITY values supposed to be unique/not shared across tables? >>> (By allowing the Name to be specified, you would allow for a sequence >>> to be shared, no?) >> No, as I said to Dmitry, it's just a way to name the generated sequence. > I haven't tried this with the alpha. > > You are saying that I will be prevented from using the same name for 2+ > columns, correct? > Of course, the second one will report the object already exist.
Adriano ------------------------------------------------------------------------------ Learn the latest--Visual Studio 2012, SharePoint 2013, SQL 2012, more! Discover the easy way to master current and previous Microsoft technologies and advance your career. Get an incredible 1,500+ hours of step-by-step tutorial videos with LearnDevNow. Subscribe today and save! http://pubads.g.doubleclick.net/gampad/clk?id=58040911&iu=/4140/ostg.clktrk Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
