Utility Queries–Structure of Tables with Identity Column

Posted by drsql on SQL Blog See other posts from SQL Blog or by drsql
Published on Sun, 02 Sep 2012 20:05:08 GMT Indexed on 2012/09/02 21:44 UTC
Read the original article Hit count: 186

Filed under:
I have been doing a presentation on sequences of late (last planned version of that presentation was last week, but should be able to get the gist of things from the slides and the code posted here on my presentation page), and as part of that, I started writing some queries to interrogate the structure of tables. I started with tables using an identity column for some purpose because they are considerably easier to do than sequences, specifically because the limitations of identity columns make...(read more)

© SQL Blog or respective owner