SQL to show tables

[flashbbeb]

I'm a newbie to MS SQL Server, and only used MySQL and Oracle SQL for elementary things like table creation.

What's the query to bring up a list of table names?

Thanks, EB

 

[flashbbeb]

found the answer - sp_tables

Of course, it doesn't give me the entire definition with field names...that would be useful!

 

[dgillz]

My website has a place where you can download the table info for Progression.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"A fine is a tax for doing wrong. A tax is a fine for doing well.
" - unknown

 

[canimp]

To obtain the field properties use this syntax
sp_help tablename

i.e. sp_help cicmpy