|
using System.Text;
namespace ObjectHelper.DBObjectType
{
public class UniqueConstraint:Index
{
public new string Script(ScriptingOptions so)
{
var sbScript = new StringBuilder();
sbScript.Append("CONSTRAINT [" + Name + "] UNIQUE " + Type);
sbScript.Append(" (");
for (int i = 0; i < Columns.Count; i++)
{
sbScript.Append("[" + Columns[i].Name + "]");
if (Columns[i].IsDescendingKey)
{
sbScript.Append(" DESC");
}
else
{
sbScript.Append(" ASC");
}
if (i != Columns.Count - 1)
{
sbScript.Append(",");
}
}
sbScript.Append(") ");
sbScript.Append(" WITH (");
sbScript.Append("PAD_INDEX = ");
if (IsPadded)
{
sbScript.Append("ON");
}
else
{
sbScript.Append("OFF");
}
sbScript.Append(", STATISTICS_NORECOMPUTE = ");
if (StatisticsNoRecompute)
{
sbScript.Append("ON");
}
else
{
sbScript.Append("OFF");
}
sbScript.Append(", IGNORE_DUP_KEY = ");
if (IgnoreDupKey)
{
sbScript.Append("ON");
}
else
{
sbScript.Append("OFF");
}
sbScript.Append(", ALLOW_ROW_LOCKS = ");
if (AllowRowLocks)
{
sbScript.Append("ON");
}
else
{
sbScript.Append("OFF");
}
sbScript.Append(", ALLOW_PAGE_LOCKS = ");
if (AllowPageLocks)
{
sbScript.Append("ON");
}
else
{
sbScript.Append("OFF");
}
if (FillFactor != 0)
{
sbScript.Append(", FILLFACTOR = " + FillFactor);
}
sbScript.Append(")");
//sbScript.AppendLine();
sbScript.Append("ON ");
if (DataSpaceType == "FG")
{
sbScript.Append("[" + DataSpace + "]");
}
else if (DataSpaceType == "PS")
{
sbScript.Append("[" + DataSpace + "] (" + PartitionedColumn + ")");
}
return sbScript.ToString();
}
}
}
|
By viewing downloads associated with this article you agree to the Terms of Service and the article's licence.
If a file you wish to view isn't highlighted, and is a text file (not binary), please
let us know and we'll add colourisation support for it.
My name is Robert Kanasz and I have been working with ASP.NET, WinForms and C# for several years.
MCSD - Web Applications
MCSE - Data Platform
MCPD - ASP.NET Developer 3.5
- Web Developer 4
MCITP - Database Administrator 2008
- Database Developer 2008
MCSA - SQL Server 2012
MCTS - .NET Framework 3.5, ASP.NET Applications
- SQL Server 2008, Database Development
- SQL Server 2008, Implementation and Maintenance
- .NET Framework 4, Data Access
- .NET Framework 4, Service Communication Applications
- .NET Framework 4, Web Applications
MS - Programming in HTML5 with JavaScript and CSS3 Specialist
Open source projects:
DBScripter - Library for scripting SQL Server database objects
Please, do not forget vote