Data Types

[larsbop]

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

 

[carp]

It would probably depend on which RDBMS you are using. In Oracle, you would look at dba_tab_columns, all_tab_columns, or user_tab_columns for this information.

 

[JamesLean]

It looks like you're using SQL Server. Use the information_schema views:

select table_name, column_name, data_type, character_maximum_length
from information_schema.columns
where table_name like 'netop%'

--James