How can I find the example of using T-SQL to drop foreign key from the table. I can not find the answer from SQL Server book online. I know this can be done by using GUI tool. But I want to know more about using SQL code. Perhaps you think this question is stupid. If you don't want to help, that's OK. But don't delete my post. I believe there are some nice people in this fourm may like to help me. Thanks in advance.