Name of a constraint

  • Thread starter Thread starter Manolain
  • Start date Start date
M

Manolain

hello all,

I created a database with access as usual, and them uploaded it for a
web application.

Now I need to change some unique and foreing key constraints I visuall
created with SQL queries, but I do not have the name of thes
contraints, as they were not created by SQL orders.

Do you know how can I get the name of these constraints?:confused:

thank you very much indeed
 
Dear Manolain:

Are you referring to a Jet database, or are you using MSDE or SQL
Server?

Either way, you can modify them through the same visual interface used
when you created them.

I work mostly with SQL Server for my Access databases, and I prefer to
script everything. My constraints are named using conventions I
prefer, so I generally know exactly how the name of any constraint or
relationship is derived. I try not to allow the database engine to
generate these names for me. This takes only a bit more effort when
scripting.

In a SQL Server database, you can query sysconstraints to see
constraints, and sysreferences for relationships. Some additional
effort is required in order to see the names of tables and columns as
these are stored as identifiers. If you're going that route, let me
know a little more specifics and I'll help you with the SQL to recover
what you're looking for.

Tom Ellison
Microsoft Access MVP
Ellison Enterprises - Your One Stop IT Experts
 
Back
Top