Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Where are Constraints?

Status
Not open for further replies.

jsteph

Technical User
Oct 24, 2002
2,562
US
I know this sounds stupid--and yes, I do know how to create contraints via DDL--but isn't there a way to view these graphically?

The Database Diagrammer seems to show these, but I can't believe that this is the only way via EM that one can graphically add/remove/edit constraints. EM has a GUI for Rules, Defaults, Indexes, Data Types, Functions, etc, etc...I just find it odd that there isn't a specific section for 'Contraints'. Is Diagrammer the only way, aside from ddl, to edit this stuff? Thanks,
--Jim
 
In EM, select a table, right click and select Design
When the design window comes up, click the indexes icon (Table with a small lightning bolt), this should bring up a properties window with 4 tabs.
One of these tabs is "Check Constraints", but other constraints are shown in the index tab.


"I'm living so far beyond my income that we may almost be said to be living apart
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top