Connecting Tech Pros Worldwide Forums | Help | Site Map

Create a table using data dictionary table as input

Newbie
 
Join Date: Oct 2007
Posts: 1
#1: Oct 18 '07
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
column3 decimal 10 yes

I need to use this table as input to create new table columns. Data will be loaded at a later time.

column1 column2 column3

Thank you in advance.

Reply