Information générale
Forum:
Microsoft SQL Server
Titre:
Can sp_pkeys be used as a function in T-SQL?
Hi. I'm attempting to make use of a SP from within a SQL statement. What I would like to return is a table of table names that have a trigger associated as well as the primary key's column name associated with the table. The problem I am having is retrieving the PK for the retrieve tables.
Here's what I have so far, but as you can see with the portion immediately following the sp_pkeys SP, it is incomplete and destined for failure.
SELECT sysobjects.name, sp_pkeys sysobjects.name
FROM sysobjects
WHERE (id IN
(SELECT DISTINCT parent_obj FROM sysobjects WHERE xtype = 'TR'))
ORDER BY name
Any suggestions?
Doug
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement