protected override void EmitCreateIndexStatement(SQL.CreateIndexStatement statement)
{
Indent();
AppendFormat("{0} ", SQL.Keywords.Create);
if (statement.IsUnique)
{
AppendFormat("{0} ", SQL.Keywords.Unique);
}
//if (AStatement.IsClustered)
// AppendFormat("{0} ", SQL.Keywords.Clustered);
AppendFormat("{0} ", SQL.Keywords.Index);
if (statement.IndexSchema != String.Empty)
{
EmitIdentifier(statement.IndexSchema);
Append(SQL.Keywords.Qualifier);
}
EmitIdentifier(statement.IndexName);
AppendFormat(" {0} ", SQL.Keywords.On);
if (statement.TableSchema != String.Empty)
{
EmitIdentifier(statement.TableSchema);
Append(SQL.Keywords.Qualifier);
}
EmitIdentifier(statement.TableName);
Append(SQL.Keywords.BeginGroup);
for (int index = 0; index < statement.Columns.Count; index++)
{
if (index > 0)
{
EmitListSeparator();
}
EmitOrderColumnDefinition(statement.Columns[index]);
}
Append(SQL.Keywords.EndGroup);
}
protected override void EmitCreateIndexStatement(SQL.CreateIndexStatement statement)
{
// literally copied from the SQL Text emitter except ...
Indent();
AppendFormat("{0} ", SQL.Keywords.Create);
// removed unique keyword and check here.
AppendFormat("{0} ", SQL.Keywords.Index);
if (statement.IndexSchema != String.Empty)
{
EmitIdentifier(statement.IndexSchema);
Append(SQL.Keywords.Qualifier);
}
EmitIdentifier(statement.IndexName);
AppendFormat(" {0} ", SQL.Keywords.On);
if (statement.TableSchema != String.Empty)
{
EmitIdentifier(statement.TableSchema);
Append(SQL.Keywords.Qualifier);
}
EmitIdentifier(statement.TableName);
Append(SQL.Keywords.BeginGroup);
for (int index = 0; index < statement.Columns.Count; index++)
{
if (index > 0)
{
EmitListSeparator();
}
EmitOrderColumnDefinition(statement.Columns[index]);
}
Append(SQL.Keywords.EndGroup);
}
protected virtual void EmitCreateIndexStatement(CreateIndexStatement statement)
{
Indent();
AppendFormat("{0} ", Keywords.Create);
if (statement.IsUnique)
{
AppendFormat("{0} ", Keywords.Unique);
}
if (statement.IsClustered)
{
AppendFormat("{0} ", Keywords.Clustered);
}
AppendFormat("{0} ", Keywords.Index);
if (!String.IsNullOrEmpty(statement.IndexSchema))
{
EmitIdentifier(statement.IndexSchema);
Append(Keywords.Qualifier);
}
EmitIdentifier(statement.IndexName);
AppendFormat(" {0} ", Keywords.On);
if (!String.IsNullOrEmpty(statement.TableSchema))
{
EmitIdentifier(statement.TableSchema);
Append(Keywords.Qualifier);
}
EmitIdentifier(statement.TableName);
Append(Keywords.BeginGroup);
for (int index = 0; index < statement.Columns.Count; index++)
{
if (index > 0)
{
EmitListSeparator();
}
EmitOrderColumnDefinition(statement.Columns[index]);
}
Append(Keywords.EndGroup);
}