SQL Server Performance

Which columns uniquely identify a row?

Discussion in 'Other SQL Server Blogs around the Web' started by Anonymous, Mar 6, 2009.

  1. Anonymous New Member

    Without seeing the table structure,If you are interested in knowing which columns uniquely identify a row in a table, you can use this system procedure EXEC sp_special_columns table_name...(<a href="http://sqlserver-qa.net/blogs/t-sql/archive/2009/03/06/5480.aspx">read more</a>)<img src="http://sqlserver-qa.net/aggbug.aspx?PostID=5480" width="1" height="1">

Share This Page