Finding field properties in SQL Server

  • Thread starter Thread starter Vik
  • Start date Start date
V

Vik

Is it possible to find out programmatically the properties of the fields as
they appear in an SQL Server database - data type (char, text, money),
precision, scale?

Thank you.
 
Yes. (You should have permission to access these tables

SELECT * FROM SYSCOLUMN
SELECT * FROM SYSTYPE
SELECT * FROM SYSOBJECT

There may also be system procedures that'll give you this information

If you haven't done so already please generate a thread in the Enterprise Development.SQL.Sql Programming group. Those guys are pretty good with this kinda stuff

Suresh

----- Vik wrote: ----

Is it possible to find out programmatically the properties of the fields a
they appear in an SQL Server database - data type (char, text, money)
precision, scale

Thank you
 
Back
Top