This T-sql script allows you to list all columns in all tables and specify if they are identity, primary key or foreign key