/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 vote235 views1 answer
How to insert multiple rows in mysql using laravel
SQL
0 vote233 views1 answer
Pgsql is not permitted to log in
SQL
0 vote229 views1 answer
Sqlite select split string
SQL
5 votes246 views1 answer
Sql table columns
SQL
0 vote235 views2 answers
Athena drop partition
SQL
24 votes242 views6 answers
Alter table name sql
SQL
11 votes248 views5 answers
Sql server reset identity
SQL
1 vote213 views1 answer
Sql injection
SQL
0 vote213 views1 answer
Postgresql array to rows
SQL
25 votes221 views3 answers
Mysql command show tables
SQL