How to obtain fields of a certain table?
I want to write an ASP.NET application with C# language that let user to manage fields of a table in a sql server 2000 database, such as adding or removing a field or changing type of fields and so on.
The question is, how can i obtain all fields of a certain table in a sql server 2000 database? Not only name of fields but other properties of the fields like nullablity, type, length and so on. How can i obtain them?
Can anyone help me?