sql server programming: http://msdn.microsoft.com/library/en-us/sqldmo/dmoref_cnst04_5td1.asp?frame=true

--
-oj
RAC v2.2 & QALite!
http://www.rac4sql.net


"Carles Beltran Vazquez" <Carles.Beltran-Vazquez@estudiant.upc.es> wrote in
message news:ehVfxARjDHA.2232@TK2MSFTNGP09.phx.gbl...
[quoted text, click to view]

What about

index.Type = SQLDMOIndex_DRIUniqueKey



--
--

Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

"Carles Beltran Vazquez" <Carles.Beltran-Vazquez@estudiant.upc.es> wrote in
message news:ehVfxARjDHA.2232@TK2MSFTNGP09.phx.gbl...
[quoted text, click to view]

Hi,

Do anyone knows how can i get the Unique constraints of a table from
SQL-DMO?

I know how to get tables, views, PK's, FK's, ... but i can't find the UNIQUE
constraint anywhere from the database, table or column object ...

Thanks in advance...



Carlos Beltrán Vázquez
antiCODE@telefonica.net
cbeltran@mss.es