> >>>> 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? Sean ------------------------------------------------------------------------------ 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
