/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 vote337 views1 answer
Quit mysql
SQL
2 votes319 views1 answer
Sql server conection string
SQL
0 vote343 views1 answer
Set Mamp mysql globally
SQL
3 votes313 views3 answers
Mysqldump: couldn
SQL
0 vote354 views2 answers
Get value from a table an insert it with other values in another table sql
SQL
0 vote315 views1 answer
Find largest table in mysql database
SQL
0 vote356 views1 answer
Mysql url
SQL
0 vote344 views1 answer
Insert data from stored procedure into table
SQL
-1 vote326 views1 answer
What is in operator
SQL
0 vote361 views1 answer
How to find all children of a record with only parent ID in sql
SQL