How to get table structure via SQL?

Dialect: SQL 92
Hi, I'm currently programming an automatic class builder that will create C# or VB class to controll a SQL Server 2000 data base. I need to be able to select the structure of the table to extract the Column names, types, max length, etc. I've done this while I was in college, but I don't seems to find any clue about it on Inet. Any idea ?

Select Struct ???

Dialect: MS SQL
http://www.simple-talk.com/dotnet/.net-framework/schema-and-metadata-retrieval-using-ado.net/
Does this help?

Dialect: MS SQL

SQL:

select table_name,ordinal_position,column_name,data_type,is_nullable,character_maximum_length from

information_schema.columns where table_name like '%TABLENAME%'

order by ordinal_position

AVANEESH

Dialect: MySQL

SQL:

describe ;

or

SQL:

select column_name,column_type,is_nullable,column_key,column_default,extra from information_schema.columns where 

table_schema='' and table_name=''

Dialect: MS SQL

SQL:

sp_help 

In SQL server

We can use this statement to get the structure of a table

EXEC sp_help <table_name>

Go to Sql server 2000 and execute " sp_help tablename" i already worked with it.it definitely works.

Thanks a lot for this...