/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

32 votes128 views6 answers
How to change column name in sql
SQL
3 votes128 views2 answers
How to open postgresql in windows
SQL
1 vote148 views1 answer
Show databases mysql docker
SQL
0 vote184 views3 answers
Insert or ignore postgres
SQL
0 vote127 views1 answer
Mysql 5.6 hierarchical recursive query
SQL
14 votes182 views1 answer
How to export db from mysql
SQL
0 vote125 views1 answer
Psql generate id in existing database
SQL
0 vote114 views1 answer
RowDataPacket
SQL
-3 votes116 views2 answers
How to enable mysql authentication on ubuntu 18.04
SQL
2 votes130 views1 answer
Sql skip the first row
SQL