I need to export the name of certain user tables along with the names of their columns and which type the column contains ie. varchar / ingeger and so on. I can figure out the table and column names - but how do i retrieve information about the data-types in each column ?
My query so far:
-------------------------
select obj.Name as Tbl,Col.Name as Col
from sysobjects obj, syscolumns col
where obj.xtype='U' and obj.Name like 'netop%' and obj.id=col.id
-------------------------
Thx. in advance
My query so far:
-------------------------
select obj.Name as Tbl,Col.Name as Col
from sysobjects obj, syscolumns col
where obj.xtype='U' and obj.Name like 'netop%' and obj.id=col.id
-------------------------
Thx. in advance