Steve Jones - SSC Editor
October 26, 2016 at 12:20 am
Comments posted to this topic are about the item The default temporal history table
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
October 26, 2016 at 1:00 am
When I have created the temporal table the table "Orders" it's history-table is called "OrdersHistory".
October 26, 2016 at 1:50 am
October 26, 2016 at 6:15 am
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.
October 26, 2016 at 7:21 am
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
Hall of Fame
October 27, 2016 at 7:58 am
Thank you for the question Steve. Learned something new this morning.
October 27, 2016 at 8:42 am
I have 2016 Enterprise. My table is 'dbo.Orders (System Versioned)' with a icon showing a small clock over the usual table.
Viewing 7 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply