Thank you, that helped me track what I was missing. On Saturday, January 30, 2021 at 10:32:56 PM UTC-7 Jeremy Evans wrote:
> On Sat, Jan 30, 2021 at 4:34 PM Michael Davis <[email protected]> > wrote: > >> Looks like support has been add for :identity to postgres. Is it >> supported in Sql Server? The schema method returns :auto_increment=>true >> for an existing sql server table with an identity column but when I call >> create_table and set :identity in the options or call the primary_key >> method (which works for Sqlite and MS Acess), I get a clustered index but >> no identity on the newly created table. > > > Sequel uses identity for primary keys by default on Microsoft SQL Server: > > $ bin/sequel -E mock://mssql > Your database is stored in DB... > irb(main):001:0> DB.create_table(:a){primary_key :id} > I, [2021-01-30T21:31:29.365817 #6223] INFO -- : (0.000004s) CREATE TABLE > [A] ([ID] integer NOT NULL PRIMARY KEY IDENTITY(1,1) > > Thanks, > Jeremy > -- You received this message because you are subscribed to the Google Groups "sequel-talk" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/sequel-talk/1bcd7122-0de1-4c9b-8253-e4739edcff70n%40googlegroups.com.
