CFDBINFO is the tag available to know about DSN with which Coldfusion interacts. This tag actulally gives you whole idea about any specific db or table or it can be a single column but It does not have much to show. Lets have a look at that tag.
[code:cf]
<cfdbinfo datasource="cfartgallery" table="art" type="columns" name="resultGallery">
<cfdump var="#resultGallery#">
[/code]
Guys, i have a piece of code which gives you all information about all databases just at once. I hope you would like it.
[code:cf]
<cfset servicefact = CreateObject("java", "coldfusion.server.ServiceFactory")>
<cfdump var="#servicefact.DataSourceService.getDatasources()#" expand="true">
[/code]
