示例#1
0
        public override void WriteToStream(IndentStream stream)
        {
            stream.Write("CONSTRAINT ");
            ConstraintName.WriteToStream(stream);

            stream.Write($" ");
            KeyType.WriteToStream(stream);

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

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

            if (OnPrimary != null)
            {
                stream.Write(" ");
                OnPrimary.WriteToStream(stream);
            }
        }
示例#2
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(" ;");
            }
        }