Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Can sp_pkeys be used as a function in T-SQL?
Message
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Miscellaneous
Thread ID:
00796849
Message ID:
00796876
Views:
16
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--
Previous
Reply
Map
View

Click here to load this message in the networking platform