如何确定数据库中一组表的最大id

I have a requirement to determine the maximum Id int value for a set of tables in my database. The column is always 'Id' and is the primary key. Is there a simple way I can make this determination without resorting to a cursor or looping?I have a requirement to determine the maximum I