<p>I need a smart way to get the data types out of INFORMATION_SCHEMA.COLUMNS in a way that could be used in a CREATE TABLE statement.  The problem is the 'extra' fields that need to be understood, such as NUMERIC<code>_</code>PRECISION and NUMERIC<code>_</code>SCALE.</p>

<p>Obviously, I can ignore the columns for INTEGER (precision of 10 and scale of 0), but there are other types I would be interested in, such as NUMERIC.  So without writing lots of code to parse the table, any ideas on how to get a sort of field shorthand out of the column definition?</p>

<p>I would like to be able to get something like :
int,
datetime,
money,
numeric**(10,2)**</p>

SMO Scripting should take care of the script generations. I believe that this is what MS uses in SQL Management Studio for script generations.
http://msdn.microsoft.com/en-us/library/ms162153.aspx
@YourComment -
```
I need a smart way to get the data types out of INFORMATION_SCHEMA.COLUMNS in a way that could be used in a CREATE TABLE statement
```
This is what you asked for. Short of that, you will have to parse the info schema view results.