Find identity columns on sqlserver
Sql script to list the columns for a given database that are acting as identity(auto-increment ) columns
Drop identity property from an existing column
If you are planning to change your db columns from identity property to non-identity property by script these codes will help you.
Drop all prefixed tables at once
Search the sql server tables with some criteria and drop them all at one with script. No need to manually select and delete them one by one. This can save your lots of time if you have lots to tables to delete.