/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 vote341 views1 answer
Sql server size of every table in a db
SQL
0 vote372 views1 answer
How to pass list as parameter in SQL query
SQL
0 vote333 views1 answer
Android studio SQLiteDatabase delete all data in database
SQL
0 vote356 views1 answer
On delete set default
SQL
0 vote341 views1 answer
Sql character index
SQL
0 vote343 views1 answer
Sql server get date of previous sunday
SQL
0 vote327 views1 answer
Pl/sql loop example
SQL
0 vote368 views1 answer
Postgresql stored procedure update table values
SQL
1 vote305 views1 answer
Sql auto timestamp
SQL
0 vote358 views2 answers
How to prevent sql injection in java
SQL