有没有办法一次在特定数据库的所有表中添加自动增量？

I am trying to add auto increment in all existing tables in a specific database, and I can do that going through the table design, flagging the identity option, but in this case I have to do it table per table, and there is a lot of tables. Is there a way to do that automatically?I am trying to add auto increment in all existi