Linked Questions

I have one Employee table in my Database which has relations to different other tables. In my application, When a user try to delete one employee which has relational data in other tables, I want to ...

Possible Duplicate: How can I list all foreign keys referencing a given table in SQL Server 2005? I'm trying to use Information_Schema to find all the FKs referencing a particular table. However ...

Apart from database architecture diagram, is there any way to get the list of all the tables with PK/FK relations?

I would like to know the detail about my foreign keys. I tried this SELECT * FROM sys.foreign_keys; But I need more than the information I can get now. Is there a way to know the columns they are ...

In MySQL, how do I get a list of all foreign key constraints pointing to a particular table? a particular column? This is the same thing as this Oracle question, but for MySQL.

I have a stored procedure that returns 80 columns, and 300 rows. I want to write a select that gets 2 of those columns. Something like SELECT col1, col2 FROM EXEC MyStoredProc 'param1', 'param2' ...

How to remove a column from an existing table? I have a table MEN with Fname and Lname I need to remove the Lname How to do it?

I am trying to drop a table but getting the following message: Msg 3726, Level 16, State 1, Line 3 Could not drop object 'dbo.UserProfile' because it is referenced by a FOREIGN KEY constraint. ...

How can I find all of the foreign key dependencies on a particular column? What are the different alternatives (graphically in SSMS, queries/views in SQL Server, 3rd party database tools, code in ....

Even though I am removing and trying to drop table, I get error, ALTER TABLE [dbo].[Table1] DROP CONSTRAINT [FK_Table1_Table2] GO DROP TABLE [dbo].[Table1] GO Error Msg 3726, Level 16, State 1, ...

Part-time reluctant DBA here. I want to change an existing primary key index from clustered to non-clustered. And the syntax is escaping me. This is how it's scripted out right now. ALTER TABLE [...

I want to find all foreign keys in my database that reference to a primary key of a certain table. For example, I have a column A in table T which is the primary key. Now I want to find in which ...

I have a local db which has FOREIGN KEY constraints. The live version of this websites DB, does not have any of these FOREIGN KEY constraints. How can I "copy/paste", import/export ONLY the FOREIGN ...

In StackOverflow, I can find the post about how to find all foreign key constraints in SQL Server. I only can find the post about how to find all foreign key constraints for a table in Oralce (List ...

I have table A with a primary key on column ID and tables B,C,D... that have 1 or more columns with foreign key relationships to A.ID. How do I write a query that shows me all tables that contain a ...