Services
Technology Web App Development Mobile App Development Windows App Development Database Development UI/UX Development Cloud Development SEO Digital Marketing Guest Posting Content Writing Artificial Intelligence Data Science ERP Development CRM Development CMS Development LMS Development Business Listing Blockchain Technology Startup Promotion AI Tools Integration
Products
Data Converter Cleaner TUC - Unit Converter Import Export Survey Manager Tweet Controller
Developer
Article Blog Forum Interview Beginner News Startup Quiz
Users
Career
Apply Job Internship
Pricing
Login Sign Up Get a Quote

forum

home / developersection / forums / how to find unique key in sql server?
Ask Question

How to find unique key in Sql Server?

Samuel Fernandes 2452 16 Sep 2017

I have 50 tables in a database. I want to fine unique key of all the tables. Is there query to know this or I have to check one by one by opening table structure.

If is it possible then please help me…

Thanks.. 

database sql serversql server 2008sql server 2012
Updated 16 Sep 2017
Samuel Fernandes
Samuel Fernandes

Other

Message

1 Answers

Sushant Mishra
Sushant Mishra 16 Sep 2017
Report Abuse

There are many method I am telling you using system stored procedure

At a time you can find unique key of single table for every table you have to run different stored procedure 

EXEC sp_special_columns Students



Here students is the table name


when you execute this procedure it will give output 

Sushant Mishra

MindStick Training