Hi,

It may help:)

select * from INFORMATION_SCHEMA.TABLES

LIST all tables in current database.

reg.
San

--- Meg Hardy <[Email Address Removed] Hi There,
>
> I am trying to write a script (or find an SP) that
> will list all the tables
> in my database (so that i can find out what is the
> longest tablename). I
> cant seem to find anything on BOL about it, do any
> of you out there know of
> anything?
>
> Thanks!
> Meg
>
>
>
**********************************************************************
> DISCLAIMER
> Any opinions expressed in this email are those of
> the individual and not necessarily of Mondial
> Assistance (UK) Ltd. This email and any files
> transmitted with it, including replies and forwarded
> copies (which may contain alterations) subsequently
> transmitted from the Company, are confidential and
> solely for the use of the intended recipient. If you
> are not the intended recipient or the person
> responsible for delivering to the intended
> recipient, be advised that you have received this
> email in error and that any use is strictly
> prohibited.
>
> If you have received this email in error please
> notify the IT support desk by telephone on +44
> (0)208 2393984 or via email to
> [Email Address Removed] including a copy
> of this message. Please then delete this email and
> destroy any copies of it. Thank you.
>
> Mondial Assistance (UK) Ltd
> Mondial House
> 102 George Street
> Croydon
> CR9 1AJ
>
> Mondial Assistance (UK) Ltd Registered in England
> No.1710361 Registered office as above
>
**********************************************************************
>
>
> This message has been checked for all known viruses
> by the
> MessageLabs Virus Scanning Service. For further
> information visit
> http://www.messagelabs.com/


__________________________________________________
Do You Yahoo!?
Yahoo! - Official partner of 2002 FIFA World Cup
http://fifaworldcup.yahoo.com
MS Sql Server LazyDBA home page