1.

One Of The Developers In My Company Moved One Of The Columns From One Table To Some Other Table In The Same Database. How Can I Find The Name Of The New Table Where The Column Has Been Moved?

Answer»

This question can be answered by querying SYSTEM views.

For SQL Server 2005 run the FOLLOWING code:

SELECT OBJECT_NAME(OBJECT_ID) TableName
FROM sys.columns
WHERE name = 'YourColumnName'

The previous QUERY will return all the tables that use the column name specified in the WHERE condition. This is a very small but a very handy script.

This question can be answered by querying system views.

For SQL Server 2005 run the following code:

SELECT OBJECT_NAME(OBJECT_ID) TableName
FROM sys.columns
WHERE name = 'YourColumnName'

The previous query will return all the tables that use the column name specified in the WHERE condition. This is a very small but a very handy script.


Discussion

No Comment Found

Related InterviewSolutions