/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

-2 votes203 views1 answer
No module named '_sqlite3
SQL
23 votes181 views3 answers
Mysqldump
SQL
7 votes220 views2 answers
Mysql check db size
SQL
0 vote204 views1 answer
Typeorm raw sql
SQL
2 votes186 views3 answers
Application.properties spring boot mysql
SQL
0 vote191 views2 answers
Postgresql display subquery as json
SQL
0 vote207 views1 answer
Mariadb set vertical output format
SQL
31 votes200 views3 answers
SQL Server change column data type
SQL
6 votes189 views1 answer
Postgresql get year
SQL
0 vote184 views2 answers
SQL FROM
SQL