Query for finding available objects and columns...

[PantherMills]

Is there any way to run a SQL query to show all the available objects and columns. I really don't know much about SQL, but I do know the line structure to do what I need if i could find the dang object and column. Thanks in advance.
Example: "select * from ? where ?"

edit: I posted this in another forum and I think it should have gone here.

 

[dhookom]

You can't use a query to retrieve the tables and fields in Access. You can use the documenter to report your table structures (and almost everything else).

Duane
MS Access MVP

 

[PantherMills]

I'm actually running MSDE. (I guess this is the lite version of SQL server.) Is there a way for me to find the table structures?

 

[dhookom]

There are system tables in SQL Server that store this information. The stored procedure sp_columns should provide all the information you need.

Duane
MS Access MVP

 

[swampBoogie]

Use the information_schema views. They are documented in Books on Line.

 

[cmmrfrds]

Example of information schema on Northwind database.

Select T.Table_type, C.Table_name, C.Column_Name, C.Data_Type
From Northwind.information_schema.tables T
Inner join Northwind.information_schema.columns C ON T.Table_name = C.Table_name
Where T.table_type='BASE TABLE'

 

[cmmrfrds]

Example of getting information from system tables.

Select so.name, sc.name from sysobjects so
inner join syscolumns sc on so.id = sc.id
--where so.xtype = 'U'

 

[PantherMills]

sp_columns and sp_tables did the trick...Thanks everyone!