Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

show structure from tables in query analyzer

show structure from tables in query analyzer

show structure from tables in query analyzer

Is it possible to show the structure from the different tables in query analyzer?

Is it possible to show the different tables in a db?


RE: show structure from tables in query analyzer

Are you asking about viewing table structure SQL Server Query Analyzer? I'm a little confused because this is an Access forum.

If you refer to SQL Server tables, SQL Server provides two methods for obtaining metadata: system stored procedures or information schema views.

I suggest using the system stored procedure, sp_help.

sp_help reports information about a database object (any object listed in the sysobjects table), a user-defined data type, or a data type supplied by Microsoft® SQL Server™.

You can read more about sp_help in SQL Books Online (BOL).

You can also use the INFORMATION_SCHEMA views. They exist in each database. Each INFORMATION_SCHEMA view contains metadata for all data objects stored in that particular database. You can read more in BOL.

If you are referring to MS Access, then you can view table structure in the Relationships window or the table design view. See Access help.


The single biggest challenge to learning SQL programming is unlearning procedural programming. -Joe Celko

SQL Article links: http://members.home.net/tlbroadbent/sqlarticles.htm

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close