/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 votes358 views1 answer
Dbms_scheduler drop_job
SQL
3 votes341 views1 answer
Delete all content in table mysql
SQL
0 vote356 views1 answer
Psql select * from table
SQL
0 vote371 views1 answer
Sql date d'aujourd'hui
SQL
0 vote355 views1 answer
Create function syntax sql server
SQL
0 vote350 views2 answers
Clear window pl sql
SQL
0 vote355 views1 answer
Empty table sqlite
SQL
0 vote352 views1 answer
How to get initials in sql
SQL
0 vote375 views1 answer
Add mysql database to power bi web
SQL
12 votes374 views6 answers
Select distinct
SQL