Show Menu
Cheatography
  1. Home >
  2. Programming >

MS SQL Server Cheat Sheet (DRAFT) by

SQL Server is a popular relational database management system developed by Microsoft. It is widely used for storing, managing, and processing data in various environments.

This is a draft cheat sheet. It is a work in progress and is not finished yet.

CREATING AND DISPLAYING DATABASES

To create a database:
CREATE DATABASE Zoo;
To list all databases on a server:
SELECT * FROM sys.da­tab­ases;

CREATING AND DISPLAYING DATABASES

To create a database:
CREATE DATABASE Zoo;