I have recently put together the following script for listing table structures which people may find useful

DECLARE @Table_Name nvarchar(128)

--SELECT * FROM INFORMATION_SCHEMA.TABLES

DECLARE myCursor CURSOR

FOR SELECT [TABLE_NAME] FROM INFORMATION_SCHEMA.TABLES...

Great summary. Thanks