C# (CSharp) Sql.AlterIndexAll Examples

Example #1

File: Table_Index_View.cs Project: sk8tz/fluid-sql

        public void AlterIndexAllRebuild()
        {
            var statement = Sql.AlterIndexAll("foo.bar").Rebuild();

            var text = Provider.GenerateStatement(statement);

            Assert.IsNotNull(text);
            Assert.AreEqual("REINDEX \"foo\".\"bar\";", text);
        }

Example #2

File: Index.cs Project: sk8tz/fluid-sql

        public void AlterIndexAllRebuild()
        {
            var statement = Sql.AlterIndexAll("foo.bar").Rebuild();

            var command = Utilities.GetCommand(statement);

            Assert.IsNotNull(command);
            Assert.AreEqual("ALTER INDEX ALL ON [foo].[bar] REBUILD;", command.CommandText);
        }