コード例 #1
0
 public override void WriteToStream(IndentStream stream)
 {
     stream.Write("CREATE INDEX ");
     IndexName.WriteToStream(stream);
     stream.Write(" ON ");
     TableName.WriteToStream(stream);
     stream.Write("(");
     OnColumns.WriteToStreamWithComma(stream);
     stream.Write(")");
 }
コード例 #2
0
        public override void WriteToStream(IndentStream stream)
        {
            stream.Write("ALTER INDEX ");
            IndexName.WriteToStream(stream);
            stream.Write(" ON ");
            TableName.WriteToStream(stream);
            stream.Write(" REBUILD");

            if (WithExpr != null)
            {
                stream.Write(" ");
                WithExpr.WriteToStream(stream);
            }
        }
コード例 #3
0
        public override void WriteToStream(IndentStream stream)
        {
            stream.Write("CREATE");

            if (IsUnique)
            {
                stream.Write(" UNIQUE");
            }

            stream.Write(" NONCLUSTERED INDEX ");
            IndexName.WriteToStream(stream);
            stream.Write(" ON ");
            TableName.WriteToStream(stream);
            stream.Write("(");
            ColumnList.WriteToStreamWithComma(stream);
            stream.Write(")");

            if (WhereExpr != null)
            {
                stream.Write(" WHERE (");
                WhereExpr.WriteToStream(stream);
                stream.Write(")");
            }

            if (WithExpr != null)
            {
                stream.Write(" ");
                WithExpr.WriteToStream(stream);
            }

            if (OnPrimary != null)
            {
                stream.Write(" ");
                OnPrimary.WriteToStream(stream);
            }

            if (IsSemicolon)
            {
                stream.Write(" ;");
            }
        }
コード例 #4
0
        public override void WriteToStream(IndentStream stream)
        {
            stream.Write("CREATE CLUSTERED INDEX ");
            IndexName.WriteToStream(stream);
            stream.Write(" ON ");
            TableName.WriteToStream(stream);
            stream.Write("(");
            OnColumns.WriteToStreamWithComma(stream);
            stream.Write(")");

            if (WithExpr != null)
            {
                stream.Write(" ");
                WithExpr.WriteToStream(stream);
            }

            if (OnPartitionSchemeNameExpr != null)
            {
                stream.WriteLine();
                OnPartitionSchemeNameExpr.WriteToStream(stream);
            }
        }
コード例 #5
0
ファイル: DropParselet.cs プロジェクト: flashlin/Samples
 public override void WriteToStream(IndentStream stream)
 {
     stream.Write("DROP INDEX ");
     IndexName.WriteToStream(stream);
 }