/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

50 votes336 views4 answers
Sql alter type of column
SQL
2 votes273 views1 answer
Set boolean flasksql
SQL
0 vote264 views1 answer
Sql server whoami
SQL
0 vote274 views1 answer
Not equal to blank in mysql
SQL
6 votes324 views3 answers
Check if string contains substring sql
SQL
0 vote256 views1 answer
Oracle execute immediate quotes
SQL
0 vote318 views1 answer
Generate sql from specific migration ef core
SQL
4 votes266 views2 answers
Select first and last row mysql
SQL
0 vote281 views1 answer
How to take sum of column with same id and different table in SQL?
SQL
1 vote267 views4 answers
Postgres extract date from timestamp
SQL