SQL Server Education (by the geeks, for the geeks)
The error “Could not find a table or object named ”. check sysobjects” tell that SQL Server can’t find the table or the object name being referenced in a query and …
Could not find a table or object named ”. check sysobjects – SQL Server Error 2501 Read MoreIt’s a common task that needs to be done on development/test environment. Though it seems that deleting a column from a table is just running an ALTER TABLE statement, however it’s …
T-SQL script delete column from a table Read MoreMany a times we need to find all tables having a particular column in a database. Here is a T-SQL script to find column in database. SELECT DB_NAME(DB_ID()) As DatabaseName, OBJECT_SCHEMA_NAME(objects.object_id,db_id()) …
T-SQL script to find column in database Read MoreMany a times need arises to find all constraints on a table. A common use case is when dropping columns from a table we need to know the dependent objects so …
T-SQL find constraints on table Read More