Link to home
Start Free TrialLog in
Avatar of RadhaKrishnaKiJaya
RadhaKrishnaKiJaya

asked on

Create column definitions of a table into another table

Hello Experts,
I am trying to create table which should contain Column Name, Data Type and Length from another Table.  Please see the example below:

Table - 1(Employee): Record Count (10)
---------------------------------------------------------
1. Employee_Name Varchar(50)
2. DateOfBirth Date
3. Salary Int
4. Active char(1)

Table - 2 (Temp)
--------------------------
1. Column_Name - any text data type say Varchar(50)
2. Data_Type - any text data type say Varchar(20)
3. Length - any int data type say Int

Data (in Table -2)
---------------------------
Employee_Name, Varchar, 50
DateOfBirth, Date, 8
Salary, Int, 10,2
Active, Char, 1

Basically I am just getting the structure from Table-1 in Table-2 in the form of columns.  Please let me know if this something possible.

Thank you in advance.

Thank you.
ASKER CERTIFIED SOLUTION
Avatar of Sharath S
Sharath S
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of RadhaKrishnaKiJaya
RadhaKrishnaKiJaya

ASKER

Excellent!!!  Thank you Sharath for you help.