And if you want to do it by your self....

To get the primary keys use storedproc sp_primarykeys on the master db

You  can also try to figure out whats inside (execute it in the db you want 
work with)
select * from syscolumns where id in (select id from sysobjects where Name 
like 'TABLE1')
which give you all the fields with all the data you need..

/Daniel


At 17:21 2001-11-21 +0000, you wrote:
>I need to know more information on the fields of a database. How can i do
>that?
>
>I need to insert some data into a field in a table but found out that this
>cannot be done. I have to insert to other fields as well. The problem is i
>do not have any information on the fields at run time. So error occurs.
>
>I need to know the following informations :
>->whether is the field a primary key field?
>->whether is the field a required fields?
>->what is the data type of the field?
>
>Also i have notice that some field are auto increament and does not allow
>inserting of data.
>
>How can i get all these information at runtime?
>
>