>>MS doesn't guarante that structure of the system tables wouldn't change in the future. Here's the query that uses information schema which conforms to the SQL-92 Standard.SELECT * From INFORMATION_SCHEMA.TABLES
>> WHERE table_type = 'BASE TABLE'
>> AND table_name <> 'dtproperties'
>
>Sergey,
>
>Thanks for the info - where would I look to find more information on "INFORMATION_SCHEMA"? See Information Schema Views in BOL.
>I'd like to do a similiar query to get the names of all the databases on a SQL Server with the exception of the system databases (i.e. master, model, etc.)
You can use
- SELECT * FROM INFORMATION_SCHEMA.SCHEMATA
- system SP sp_helpdb.
--sb--