Advanced Search

Return to Snippet

Revision: 19566
at October 26, 2009 05:31 by marcocs
Initial Code 
SELECT  'ALTER TABLE ' + TABLE_SCHEMA + '.[' + TABLE_NAME
        + '] DROP CONSTRAINT [' + CONSTRAINT_NAME + ']'
FROM    information_schema.table_constraints
WHERE   CONSTRAINT_TYPE = 'FOREIGN KEY'
Initial URL 

                                

                                                            

                                    

                                        

                                        Initial Description
                                        

                                    

                                    
Delete All Foreign Keys in a database;
(make sure you USE keyword)

                                

                                                            

                                    

                                        

                                        Initial Title
                                        

                                    

                                    
Delete All Foreign Keys

                                

                                                            

                                    

                                        

                                        Initial Tags
                                        

                                    

                                    
sql

                                

                                                            

                                    

                                        

                                        Initial Language
                                        

                                    

                                    
SQL