How to make script of all constraints

Question

How to make script of all constraints

rocky.singh12345

Grasshopper

Points: 16
More actions
May 19, 2011 at 3:21 am

#236570

Hi,
I have to change collation of my DB for that I need to drop all the constraints and recreate them after running the collation change script at my DB. May I know how can I make the script of all constraints of my DB?

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

toddasd SSCertifiable Points: 6298 More actions · Answer 1

SELECT * FROM INFORMATION_SCHEMA.CONSTRAINT_TABLE_USAGE

______________________________________________________________________________
How I want a drink, alcoholic of course, after the heavy lectures involving quantum mechanics.

rocky.singh12345 Grasshopper Points: 16 More actions · Answer 2

I need to make scripts of all the constraints not to see them.

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 3

rocky.singh12345 (5/19/2011)
I need to make scripts of all the constraints not to see them.

You are going to have to modify the SELECT Statement provided to you and add strings to specify the TABLE, CONSTRAINT_NAME etc.

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/