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

 

[JayKusch]

when you say "objects and columns" are you refering to tables and columns?

Thanks

J. Kusch

 

[PantherMills]

yes...I've found that "sp_columns" and "sp_tables" does the trick...

 

[SQLSister]

IN query Analyzer, the object browser shows all the tables and columns and you can drag them to your code so you never misspell them!