/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 vote353 views1 answer
Vowels in sql
SQL
16 votes356 views4 answers
Find duplicates mysql
SQL
-1 vote358 views2 answers
First letter capital in mysql query
SQL
0 vote384 views1 answer
Mysql workbench Error Code: 2013. Lost connection to MySQL server during query
SQL
1 vote394 views1 answer
Drop colum oracle 18c
SQL
0 vote351 views1 answer
Sql select most frequent value in column
SQL
1 vote425 views1 answer
Postgresql can you have null foreign key
SQL
2 votes365 views1 answer
Mariadb json select
SQL
0 vote369 views1 answer
Mysql equivalent decode oracle
SQL
0 vote342 views1 answer
Postgres jsonb array push new element
SQL