Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Can sp_pkeys be used as a function in T-SQL?
Message
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Syntaxe SQL
Divers
Thread ID:
00796849
Message ID:
00796876
Vues:
15
You're welcome.

>Thanks!!
>
>>Can you use INFORMATION_SCHEMA instead?
SELECT * FROM   INFORMATION_SCHEMA.TABLE_CONSTRAINTS tc
>>	JOIN INFORMATION_SCHEMA.CONSTRAINT_COLUMN_USAGE ccu
>>		ON tc.CONSTRAINT_name = ccu.CONSTRAINT_name
>>	WHERE CONSTRAINT_type = 'PRIMARY KEY'
>>
>>
--sb--
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform