/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 vote200 views1 answer
Mysql add root password
SQL
0 vote200 views1 answer
Optimize sql query
SQL
1 vote187 views1 answer
Reutrn string after character sql
SQL
3 votes221 views2 answers
Update Query in SQL Server
SQL
1 vote219 views1 answer
Key validation sql
SQL
4 votes229 views3 answers
Employee name starting with in sql
SQL
0 vote342 views1 answer
Dublicate row sql
SQL
0 vote208 views2 answers
Sql query in dax power bi
SQL
0 vote205 views1 answer
Timestamp(0) postgresql
SQL
0 vote207 views1 answer
Linked server delete openquery
SQL