/SQL/Query to generate query to drop primary keys or foreign key in ms sql server

Query to generate query to drop primary keys or foreign key in ms sql server

DECLARE @sql NVARCHAR(MAX) = N'';

SELECT @sql += N'
ALTER TABLE ' + QUOTENAME(OBJECT_SCHEMA_NAME(parent_object_id))
    + '.' + QUOTENAME(OBJECT_NAME(parent_object_id)) + 
    ' DROP CONSTRAINT ' + QUOTENAME(name) + ';'
FROM sys.foreign_keys WHERE QUOTENAME(OBJECT_NAME(parent_object_id)) LIKE '%[tblAccount]%'

PRINT @sql;

Similar codes

0 vote135 views1 answer
Sql query for getting data with join and count
SQL
0 vote137 views1 answer
Aktor yang pernah terlibat di film bergenre Aksi di sql
SQL
0 vote125 views1 answer
How to get data between a last week in mysql
SQL
0 vote136 views1 answer
How to add unique key constraint in mysql
SQL
36 votes124 views3 answers
Finding duplicate column values in table with sql
SQL
0 vote133 views1 answer
Soql update query
SQL
7 votes111 views1 answer
Safe mode mysql
SQL
2 votes137 views2 answers
How to rename column name in sql server using query
SQL
0 vote126 views1 answer
How to check if there is no database schema
SQL
0 vote142 views8 answers
Convert sql query to linq online
SQL