How to read rules created on SQL Server database from application?

what do you mean by "rules inside SQL database"?

Hi Dirk,

Great. But how to query specific database ?

Thank you.

sys.objects is part of each DB, and refers to its objects only. So you access it like any other table.

Qlemo is correct. If you had to run

SELECT * FROM sys.objects 

Select allOpen in new window

in a new query window for your selected database, you will see familiar results with the objects in the selected database. Look at the fields type and type_desc to identify what it returns.

I created the rule on a test database of mine.
When I run the following SQL:

SELECT * 
	FROM sys.objects so
	JOIN sys.columns sc
		ON so.object_id = sc.rule_object_id
	WHERE 
		OBJECT_NAME(sc.object_id) = 'tblPeople' -- table name
		AND sc.name = 'age'  --column name

Select allOpen in new window

The results returned are

Hi Dirk,

Thank very much for your help.