Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
shure
Starting Member
3 Posts |
 Posted - 2007-11-14 : 09:45:15
|
| im having a bit of a problem displaying the integrity constraints i have set. I need to show the table name, contraint name and contraint type, but i cant find out how to do this anywhere.can anyone help?thanks |
|
|
elancaster
A very urgent SQL Yakette
1208 Posts |
Posted - 2007-11-14 : 09:59:14
|
| select * from INFORMATION_SCHEMA.TABLE_CONSTRAINTSEm |
 |
|
|
shure
Starting Member
3 Posts |
Posted - 2007-11-14 : 10:07:10
|
| thanks for the reply, but i keep getting the error "table or view does not exist"am i making a rookie mistake (well i am a rookie but hey)thanks again |
|
|
|
elancaster
A very urgent SQL Yakette
1208 Posts |
Posted - 2007-11-14 : 10:34:22
|
| are you using SQL2000 or 2005?Em |
|
|
|
shure
Starting Member
3 Posts |
Posted - 2007-11-14 : 10:51:19
|
| sql+ 2005 i think. its version 10.2.0.1.0 |
|
|
|
elancaster
A very urgent SQL Yakette
1208 Posts |
Posted - 2007-11-14 : 10:58:41
|
| SQL+ ...as in SQLPLus?are you actually using SQL Server or Oracle?Em |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-11-14 : 22:31:28
|
| Sounds Oracle 10g. |
|
|
|
|
|
|
how do i display integrity constraints i set?