how to write query to find the database objects in databases
-
Rmesh wrote:
i need to write query to find the databases presented in the database objects
:confused: I have no idea what that means.
Upcoming Scottish Developers events: * Glasgow: Tell us what you want to see in 2007 My: Website | Blog | Photos
-
Rmesh wrote:
i need to write query to find the databases presented in the database objects
:confused: I have no idea what that means.
Upcoming Scottish Developers events: * Glasgow: Tell us what you want to see in 2007 My: Website | Blog | Photos
-
i have foind out the databases present in the database for ex, if we have databases like crm,sqm,love etc then i have to write the query to list out these databases
Rmesh wrote:
i have foind out the databases present in the database
Do you mean the databases present on the server?
Rmesh wrote:
i have to write the query to list out these databases
If you have SQL Server 2000 (and you haven't specified which technology you are using - please state this, it is important) the query would be something like:
SELECT * FROM master..sysdatabases
Upcoming Scottish Developers events: * Glasgow: Tell us what you want to see in 2007 My: Website | Blog | Photos
-
Rmesh wrote:
i have foind out the databases present in the database
Do you mean the databases present on the server?
Rmesh wrote:
i have to write the query to list out these databases
If you have SQL Server 2000 (and you haven't specified which technology you are using - please state this, it is important) the query would be something like:
SELECT * FROM master..sysdatabases
Upcoming Scottish Developers events: * Glasgow: Tell us what you want to see in 2007 My: Website | Blog | Photos
-
check out the INFORMATION_SCHEMA views. they will give you all this data. in particular for tables in views: select * from INFORAMATION_SCHEMA.TABLES if you want a comprehensive data dictionary of your database, check out the link in my sig below.