/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 vote100 views1 answer
Sql truncate table referencing itself
SQL
0 vote140 views1 answer
Sql grant select only
SQL
1 vote1.8K views1 answer
Dropping a constraint in ms sql
SQL
20 votes138 views5 answers
Sql show tables
SQL
-1 vote137 views2 answers
Get day in sql
SQL
5 votes179 views1 answer
How to use rank function in sql
SQL
0 vote139 views1 answer
Sequelize postgresql schema
SQL
0 vote147 views1 answer
Configure: error: Cannot find libpq-fe.h. Please specify correct PostgreSQL installation path
SQL
1 vote147 views1 answer
Mysql size int
SQL
0 vote155 views1 answer
Oracle allow space to user
SQL