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 |
|
chetancool
Starting Member
34 Posts |
 Posted - 2004-10-21 : 06:52:20
|
| Hi group...I m having a table called 'PriceInformation. when i try to drop the same with 'drop table command', it is showing error that u cannot drop the table, some rules are binded with it.. How can i view that which rules are binded with the table?cjain |
|
|
Kristen
Test
22859 Posts |
Posted - 2004-10-21 : 08:16:10
|
| sp_help 'MyTableName' may tell youKristen |
 |
|
|
rockmoose
SQL Natt Alfen
3279 Posts |
Posted - 2004-10-21 : 13:33:05
|
| sp_fkeys 'table_name'ov course sp_help will do the trick to/rockmoose |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2004-10-21 : 13:39:20
|
| I rather fear them's is rules that are "binded", not FKs ...Kristen |
|
|
|
rockmoose
SQL Natt Alfen
3279 Posts |
Posted - 2004-10-21 : 14:10:48
|
| If you have rules bound to some of your table columns, would that matter ?, you should be able to drop the table anyhow !?Methinks FK's is the problem.rockmoose/* Chaos is the nature of things...Order is a lesser state of chaos */ |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2004-10-21 : 14:39:27
|
| Of couse you can, silly me. I've got [legacy] RULEs and there's never been a problem dropping the tables.Dunno what chetancool meant by "cannot drop the table, some rules are binded with it.. " - doesn;t sound like FK, but.Kristen |
|
|
|
|
|
|
Problem in dropping a table.