Hello,
Please bear with me I'm new to t-sql.
I've had no luck trying to figure this out yet using sql code. I need to use an existing table (data dictionary) as input for creating a new table.
Using MS SQL 2000 t-sql.
Existing table has the new table column characteristics and looks like this,
FieldName Type Size Nulls
column1 char 20 no
column2 decimal 5 yes
...