Use the system stored procedure:

sp_depends authors

You will get a list of database objects dependent on the authors table.