Wednesday, August 6, 2008

SQL 2005 Database Schema

I needed a way to view the schema of the database (all tables, columns, data types, etc.) and I found a blog (http://www.digitalmediaminute.com/article/1278/printing-sql-server-database-schema) that provided a quick way to get this. It is an ASP (classic) page that you drop into IIS, change the server name, database name, user ID, and password and boom! You now have a web page that quickly displays the schema. This is great for printing, discussing, saving, or using as a comparison of another database.

No comments: