Write the exact SQL syntax to create a sequence script and explain how you would use it to auto-populate primary keys.
