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 |
|
Mamatha
Posting Yak Master
102 Posts |
 Posted - 2005-02-17 : 01:22:28
|
| HiI want to know the information of a table,means i want to retrieve constraints on a table,because i have converted SQL Server database to Access database using ASP.While at the time of conversion if SQL table have a primary key and have many data then that is not converted into Access.What is the reason?Please give me a solution to retrieve constrains on a table.Mamatha |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2005-02-17 : 05:47:31
|
look at:select * from INFORMATION_SCHEMA.CONSTRAINT_COLUMN_USAGEGo with the flow & have fun! Else fight the flow  |
 |
|
|
rockmoose
SQL Natt Alfen
3279 Posts |
Posted - 2005-02-17 : 11:12:50
|
| For a specific table you could do:exec sp_helpconstraint 'tablename'see also sp_pkeys, sp_fkeys, sp_helprockmoose |
|
|
|
|
|
|
How to retrieve costraints on table in SQL server