How to find Databases with its Table value

Question

 I want to find databases in the particular System.In the query i want to get  a table value in tha database. i means , i created database, that database there a table with information about database ,they are StartDate,CloseDate,Description.In the databases diplay iwant to get these information also displays..How it possible?

Answer 1

If the reply from Suthish or John answered the question, then Abdu needs to check the checkbox specifying that it answered the question. Otherwise Abdu needs to clarify what is needed. It definitely is not clear to me what is needed.

Answer 2

It seemed clear to me that Abdu is trying to programmatically find a table in a database that has certain columns.  Yes, StartDate and CloseDate are not system fields, but I didn't say that they were.  My post was to get him moving on the right track and sys.databases is a good place to start exploring the database structure.

To get a list of all databases and corresponding tables and columns, the following query will work:

sp_msforeachdb @command1='USE ?;SELECT * FROM INFORMATION_SCHEMA.Columns'

Answer 3

I doubt that StartDate and CloseDate are system fields describing a database or a table in a database. I assume that you are asking how to get data from a table in your application. I think your question is being misunderstood. Your question says "find databases in the particular System" and "table with information about database" yet I think what you are trying to say is very different from what we interpret that as meaning.

So you need to get StartDate, CloseDate and Description from a table in a database, correct? You created the database and you created the table, correct? Do you know what the name of the database is and the name of the table? If not, then why not?

Answer 4

 refer article: How to get Database information's - Oracle, Sql Server

Answer 5

select * from sys.databases

This will give you some information, and you can use the "database_id" column to join to the other sys tables to get more details on each database.