Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Getting the constraint of a column
Message
 
 
To
07/10/2004 01:35:41
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00949432
Message ID:
00949479
Views:
5
Mike,

You can use INFORMATION_SCHEMA view
SELECT * FROM pubs.INFORMATION_SCHEMA.CONSTRAINT_COLUMN_USAGE
	WHERE table_name = 'authors'
		AND column_name = 'au_id'
>
>Is there a way to get the constraint of a particular column in a SQL Table?
>I need to check if a column containts a Constraint.
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform