retrieve all database names

[yuvachandra]

Hi all,, Plz let me know the query to retrieve all the databases names present in sqlserver..!or give me some urls to releted topics

[Krish KP]

sp_databases or SELECT * FROM sysdatabases

Regards KP

[yuvachandra]

hello krish....plz let me know the sql query for retrieving the user tables present in the selected database thanqs in advance..

[Krish KP]

sysobjects table holds all objects created in the database SELECT * FROM sysobjects WHERE xtype = 'U' xtype column holds object type like U-Table / V-View / P-Storedprocedure /...

Regards KP

[yuvachandra]

Thanqs Krish...this code sippet is quied for my requirement