/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

1 vote302 views1 answer
Org.h2.jdbc.jdbcsqlsyntaxerrorexception
SQL
1 vote325 views1 answer
Woocommerce mysql price table
SQL
0 vote323 views1 answer
Create database like
SQL
0 vote304 views2 answers
Return the number of records in a single table mysql
SQL
0 vote345 views1 answer
Sql query to find percentage of null values in a table
SQL
2 votes312 views1 answer
Copy all values of a column to another column in sql in same table
SQL
0 vote320 views4 answers
Forenkey code alchemy sql
SQL
-1 vote312 views1 answer
Su: Authentication failure mysql
SQL
0 vote309 views2 answers
Python mysql create table if not exists
SQL
1 vote311 views1 answer
Sqlite3 read only
SQL