Drop all tables, all views, and all stored procedures
exec sp_MSforeachtable "DROP TABLE ? PRINT '? has been dropped' "
SQL Server 2005
Find a column by name
SELECT t.name AS table_name, SCHEMA_NAME(schema_id) AS schema_name, c.name AS column_name FROM sys.tables AS t INNER JOIN sys.columns c ON t.OBJECT_ID = c.OBJECT_ID WHERE c.name LIKE '%ShipCode%' ORDER BY schema_name, table_name;
SQL Server 2005
Search through stored procedures for code
select so.name as 'storProc' from sysobjects so join syscomments sc on so.id=sc.id where so.type='P' and sc.[text] like '%BIT_YOU_WANT_TO_FIND%'