IT Developers/SQL

SQL Syntax

eeh_gnas 2020. 11. 19. 10:24

Some of The Most Important SQL Commands

  • SELECT - extracts data from a database
  • UPDATE - updates data in a database
  • DELETE - deletes data from a database
  • INSERT INTO - inserts new data into a database
  • CREATE DATABASE - creates a new database
  • ALTER DATABASE - modifies a database
  • CREATE TABLE - creates a new table
  • ALTER TABLE - modifies a table
  • DROP TABLE - deletes a table
  • CREATE INDEX - creates an index (search key)
  • DROP INDEX - deletes an index

'IT Developers > SQL' 카테고리의 다른 글

SQL SELECT DISCINCT  (0) 2020.11.19
SQL SELECT  (0) 2020.11.19
[MSSQL] 샘플 데이터베이스 삽입  (0) 2020.11.19
SQL Basic Appendix  (0) 2020.11.18
[SQL] Fundamentals  (0) 2020.11.16