show structure from tables in query analyzer

[Guest_imported]

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?

greetings,
jack

 

[tlbroadbent]

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.
Terry

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

SQL Article links:

http://members.home.net/tlbroadbent/sqlarticles.htm