The default temporal history table

Question

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

mickegohle SSC Veteran Points: 234 More actions · Answer 1

When I have created the temporal table the table "Orders" it's history-table is called "OrdersHistory".

Carlo Romagnano SSC-Insane Points: 22668 More actions · Answer 2

SSC-Insane

Points: 22668

October 26, 2016 at 1:50 am

Very interesting!

Thanks!

George Vobr SSCrazy Eights Points: 9996 More actions · Answer 3

+1

I was interested that the anonymous is default, but I guess it's better created

a new table with the name of the history table explicitly defined.

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 4

And that's why we don't let SQL Server use the defaults 😀

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

daniel.plocinik Hall of Fame Points: 3288 More actions · Answer 5

Thank you for the question Steve. Learned something new this morning.

Revenant SSC-Forever Points: 42467 More actions · Answer 6

I have 2016 Enterprise. My table is 'dbo.Orders (System Versioned)' with a icon showing a small clock over the usual table.