The text of this article is not in this database — only its details are. Read it on the old site: Database Objects Information Using SQL Query in SQL Server
5 Comments
Join the conversation! Your thoughts help the community grow.
Sign in to leave a comment.

Gaurav GuptaPosted Apr 25, 2012, 12:00 AM
Hello, I want to get all the triggers information that are associated with a specified with a table, How?
Lajapathy ArunPosted Apr 23, 2012, 7:06 AM
Sorry,Don't know about factory method.
Lajapathy ArunPosted Apr 23, 2012, 7:05 AM
You can get information of database using select * from sys.databases use dbname or id to filter
Arjun PanwarPosted Apr 22, 2012, 11:54 PM
Hi, I want to know that what is factory method design pattern?
Arjun PanwarPosted Apr 22, 2012, 11:49 PM
Hi, I want to know that how to get information about a specified database or about all Adaptive Server databases.