How to get table structure via SQL?

#1 (**permalink**) 02-08-2007, 10:24 PM

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 ???

#2 (**permalink**) 02-09-2007, 06:47 AM

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

#3 (**permalink**) 03-02-2007, 12:19 AM


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

[b]AVANEESH[b]

#4 (**permalink**) 03-11-2007, 06:11 PM


DESCRIBE ;

or


SELECT column_name,column_type,is_nullable,column_key,col  umn_default,extra FROM information_schema.COLUMNS WHERE 

table_schema='' AND table_name=''

#5 (**permalink**) 04-01-2007, 01:52 PM


sp_help

#6 (**permalink**) 11-29-2007, 01:04 PM

In SQL server

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

EXEC sp_help <table_name>

lavanya · #7 (**permalink**) 01-22-2008, 04:16 AM

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

#8 (**permalink**) 08-20-2008, 05:24 AM

Quote:

Originally Posted by Avaneesh


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

[b]AVANEESH[b]

Thanks a lot for this...

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search

LinkBacks (?) LinkBack to this Thread: http://www.sqlrecipes.com/sql_questions_answers/how_get_table_structure_via_sql-92/
Posted By	For	Type	Date
superbullet's bookmarks on del.icio.us	This thread	Refback	05-16-2008 02:04 PM

User Name		Remember Me?
Password

How to get table structure via SQL?

ANSWER(S):