How to get table structure via SQL?

#1 (**permalink**) 02-08-2007, 09: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, 05:47 AM

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

#3 (**permalink**) 03-01-2007, 11:19 PM


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, 05: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, 12:52 PM


sp_help

#6 (**permalink**) 11-29-2007, 12: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, 03:16 AM

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

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

User Name		Remember Me?
Password

vBulletin Message

Cancel Changes

How to get table structure via SQL?

ANSWER(S):