SQL Server Cheat Sheet

# SQL Server Cheat Sheet.md

• F5 to execute the query in console
• CTRL+l to execute equivalent of MySQL EXPLAIN

cheats.md

TABLE

ALTER TABLE schema-name.table-name
    ADD column-name BIT DEFAULT 0

INDEX

CREATE INDEX the-index-name ON schema-name.table-name (column-name);

-- Get index list on table
EXEC sp_helpindex 'schema-name.table-name'
GO

FOREIGN KEY

ALTER TABLE schema-name.table-name
	ADD CONSTRAINT foreign-key-name FOREIGN KEY (column-name) REFERENCES foreign-table-name(foreign-column-name);

ALTER TABLE schema-name.table-name
    DROP CONSTRAINT foreign-name;
    
-- Is a foreign key exists
SELECT * 
    FROM sys.foreign_keys 
    WHERE object_id = OBJECT_ID(N'[dbo].[foreign-key-name]') 
        AND parent_object_id = OBJECT_ID(N'[dbo].[table-name]')

CONDITIONNAL EXECUTION

IF EXISTS (SELECT * FROM table-name WHERE 1=1)
BEGIN
    -- do stuff
END