<div>
do you mean just create unique constraint?
</div>


do you mean just create unique constraint?

<div>
if you have &nbsp; create table tbl ( f1 int, f2 char(1), f3 bit, f4 datetime )<br />
and you want to make sure that f4 (the datetime) is unique, you'd add a constraint using<br />
<br />
alter table tbl add constraint uq_f4 unique(f4)<br />

</div>


if you have   create table tbl ( f1 int, f2 char(1), f3 bit, f4 datetime )
and you want to make sure that f4 (the datetime) is unique, you'd add a constraint using

alter table tbl add constraint uq_f4 unique(f4)


<div>
Can you provide the steps in the Studio Management Tool?<br />
For example:<br />
Select &quot;Contstraints&quot;, right click and select &quot;New Constraint&quot;.... etc.<br />
<br />
Thanks
</div>


Can you provide the steps in the Studio Management Tool?
For example:
Select "Contstraints", right click and select "New Constraint".... etc.

Thanks

<div>
<div class="content wysiwyg-content">
Hi Experts,<br />
<br />
Please give me all the necessary steps in order to set a non-key field to unique constraint.<br />
Note that I am using the &quot;SQL Server Management Studio Express&quot;.<br />
<br />
Thanks in advance!
</div>
</div>


Hi Experts,

Please give me all the necessary steps in order to set a non-key field to unique constraint.
Note that I am using the "SQL Server Management Studio Express".

Thanks in advance!

MS SQL 2005 Express :: Give non key field UNIQUE constraint?

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.