I Have a SQL TABLE called (PRODUCT)
Initially i have create with 2 columns(COL1 int,COL2 varchar(20)) on 01/Jan/13.
Later on i added new column COL3 VARCHAR(20) on 05/Jan/13.But i altered datatype of COL3 as Int on 07/01/13. I want a query for list out the column name ,created date and modified date.
Query out put should be:
COL1<--> 01/Jan/13<--> 01/Jan/13
COL2<--> 01/Jan/13<--> 01/Jan/13
COL3<--> 05/Jan/13<--> 07/Jan/13