If you drop a column with the ALTER TABLE statement, all the indexes (simple and composite) in which the column participates are also dropped. See CREATE INDEX Statement for more information on ...

I'm trying to create a new database diagram in SQL Server so that I can refer to it for relationships and that sort of thing. I opened SQL Server Enterprise Manager, created a new diagram, added ...