• But how do I figure out if seed and increment were specified explicitly or not?

    For example,

    CREATE TABLE tbl_1 ( col_1 INT IDENTITY )

    versus

    CREATE TABLE tbl_1 ( col_1 INT IDENTITY( 1, 1 ) )