renatoassis01/check_constraint_pk.sql

Created June 21, 2016 16:44

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/renatoassis01/1110a7c43bb7f3b1593665b63b8cfb73.js"></script>
Save renatoassis01/1110a7c43bb7f3b1593665b63b8cfb73 to your computer and use it in GitHub Desktop.

Download ZIP

Check constraint primary key Sql Server

Raw

check_constraint_pk.sql

	SELECT T.name 'COM PK'
	FROM SYS.Tables T
	WHERE OBJECTPROPERTY(object_id,'TableHasPrimaryKey') = 1 -- 1 or 0
	AND type = 'U'

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment