Here's another possible solution although it does create an extra useless column.  However this technique might be useful for other applications.

use...

You can use my stored proc, sp_tableinfo, to get a concise listing of most of a table's important properties:

http://www.databasejournal.com/scripts/article.php/1493111