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?

Sam Hobbs · Answer

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.

John Penn · Answer

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'

Sam Hobbs · Answer

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?

Suthish Nair · Answer

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

John Penn · Answer

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.