16 August 2013

Some of The Important SQL Server Commands

  1. SELECT - extracts data from a database
  2. UPDATE - updates data in a database
  3. DELETE - deletes data from a database
  4. INSERT INTO - inserts new data into a database
  5. CREATE DATABASE - creates a new database
  6. ALTER DATABASE - modifies a database
  7. CREATE TABLE - creates a new table
  8. ALTER TABLE - modifies a table
  9. DROP TABLE - deletes a table
  10. CREATE INDEX - creates an index (search key)
  11. DROP INDEX - deletes an index

No comments:

Post a Comment