/***Getting Table structure in a cool nice manner to view is not easy in SQL 
Server. The inbuilt SP_hel will display structure but not in any useful or 
readble way.
Heres a simple query that will take TableName as input and would display its 
structure. You could include more columns either
from SYSCOLUMNS or SYSTYPES table based on your wish to view.***/
alter Proc DispTableStructure (@tableName varchar(50)) as
if exists (select * from dbo.sysobjects where id = 
object_id(N'[dbo].['+@tableName+']') and OBJECTPROPERTY(id, N'IsUserTable') 
=1)
	select left(a.name,30) Name,left(b.name,15) 
Type,a.length,a.prec,a.scale,allownulls from syscolumns a join systypes b on 
a.xusertype=b.xusertype where id=object_id(@tableName) order by name
else
	Print 'No Table named '+@tableName + ' found in the Database'