Commonly Used SQL queries

These are some of the commonly used SQL queries at work, just to note them down for easier access:

To add a contraint (foreign key):

alter table pro_product add constraint FK_53_PRO_Category_FK foreign key (PRO_Category_FK) references PRO_Category(Id) on delete cascade

To delete a constaint:

alter table pro_product drop constraint FK_53_PRO_Category_FK

To add new column:

Alter table MEM_Member Add Password nvarchar(255) null

If you think this post is useful, please recommend me at the bottom of the page. ;)

Search