I have a query but it display only the column name
But i want sequential number alobg with the column name
SELECT COLUMN_NAME
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME ='tbl_product_desc'
ORDER BY ORDINAL_POSITION
I want a ouptu lik this
Column name Number
Pro_Id 1
Item_Code 2
Descrip 3
Category _ 4
Image_ 5
Curren_cost 6
Whole_cost 7
Reta_cost 8