Hi All,

 

I got two questions to ask

 

1) I hav created a trigger which handles refrential integrity i wish to know if at all there is a way by which we could retrive the number of primary keys (columns) of a table.

 

2) I want trigger on CREATE TABLE which will return the number of primary keys defined during the creation of the database.

 

Looking forward for ur replies.

Cheers

Prasad.