<div>
<div class="content wysiwyg-content">
How do I modify a column in management studio to add a constraint that all records in the column must be unique?<br />
<br />
ID &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;int &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(PK, Auto Increment)<br />
Expired &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;bit &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<br />
Filename &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;nvarchar(50) &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<br />
Name &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;nvarchar(50) &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<br />
FileType &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;nvarchar(50) &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<br />
BackupFile &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;nvarchar(50) &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<br />
Client &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;int &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<br />
PlacementType &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;int &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<br />
<br />
Filename should be unique. Thanks!<br />
<br />
<br />

</div>
</div>


How do I modify a column in management studio to add a constraint that all records in the column must be unique?

ID	int	(PK, Auto Increment)
Expired	bit	
Filename	nvarchar(50)	
Name	nvarchar(50)	
FileType	nvarchar(50)	
BackupFile	nvarchar(50)	
Client	int	
PlacementType	int	

Filename should be unique. Thanks!




Unique column

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.