SQL 2008

SQL Table Definition : This sql query is used to find table
definition without using enterprise manager table design.

Code :

SELECT a.[name] as 'Table',
  b.[name] as 'Column',
  c.[name] as 'Datatype',
  b.[length] as 'Length',
  CASE
   WHEN b.[cdefault] > 0 THEN d.[text]
   ELSE NULL
  END as 'Default',
  CASE
   WHEN b.[isnullable] = 0 THEN 'No'
   ELSE 'Yes'
  END as 'Nullable'
FROM  sysobjects a
INNER JOIN syscolumns b
ON  a.[id] = b.[id]
INNER JOIN systypes c
ON  b.[xtype] = c.[xtype]
LEFT JOIN syscomments d
ON  b.[cdefault] = d.[id]
WHERE a.[xtype] = 'u'
-- 'u' for user tables, 'v' for views.
and a.[name]='table name'
AND  a.[name] <> 'dtproperties'
ORDER BY a.[name],b.[colorder]