November 2009 Entries
This should work for SQL Server 2005/2008-- ALTER SCHEMA SchemaNameForTarget TRANSFER SchemaNameOfSource.MyTableName example: ALTER SCHEMA RiskEvaluation TRANSFER dbo.ConvertibleDebenture...
To create a index on a single column, do this: CREATE INDEX IDX_FERC ON FERC(FercName) In some cases, you may have a need to combine columns to hasten known unique combinations. This is knonw as a composite key. An example: CREATE INDEX IDX_OperatingCompanyFERC ON FERC(OpCompanyID,FercName)