/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

3 votes262 views1 answer
Postgresql where current year
SQL
0 vote298 views2 answers
Sql server select where date
SQL
0 vote302 views1 answer
Mysql disable query caching
SQL
0 vote261 views1 answer
Mysql find foreign key references
SQL
0 vote282 views1 answer
Mysql workbench search all tables
SQL
0 vote303 views1 answer
Commit transaction sql
SQL
1 vote293 views2 answers
Find a column in all tables mysql
SQL
0 vote320 views1 answer
Copy data from one postgres container to another
SQL
0 vote308 views2 answers
Auto increment column in mysql query results
SQL
0 vote317 views1 answer
Raiserror with nowait
SQL