T—SQLコマンドのまとめ

もっと読む

      CREATE DATABASE      

      DROP DATABASE      

    CREATE TABLE    

    DROP TABLE    

         ALTER TABLE    ALTER COLUMN          

          ALTER TABLE    ADD          

         ALTER TABLE    DROP COLUMN     

          ALTER TABLE    ADD CONSTRAINT     PRIMARY KEY (     ) 

          ALTER TABLE    ADD CONSTRAINT     FOREIGN KEY (    
 ) REFERENCES     （     ） 

        ：alter table    drop constraint    

           ALTER TABLE    ADD CONSTRAINT     DEFAULT     FOR           

            ALTER TABLE    ADD CONSTRAINT    _CHECK CHECEK (       ) 

           ALTER TABLE    ADD CONSTRAINT     UNIQUE（         ） 

        INSERT INTO    valueS (        ) 

  A       B  INSERT INTO  B  SELECT     FROM  A  

           UPDATE    SET         

          UPDATE    SET         WHERE         

         DELETE FROM    TRUNCATE TABLE    

       DELETE FROM    WHERE        

          SELECT     FROM    WHERE      

  ORDER BY   SELECT     FROM    ORDER BY       SELECT     FROM    ORDER BY       DESC 

  AS   SELECT     AS           FROM    

  TOP   SELECT TOP N     FROM    SELECT TOP N PERCENT     FROM    

SUM   SELECT SUM (   ) FROM    

AVG   SELECT AVG (   ) FROM    

COUNT   SELECT COUNT (   ) FROM    

MAX   SELECT MAX (   ) FROM    

MIN   SELECT MIN (   ) FROM    

  GROUP BY   SELECT     FROM    GROUP BY       

  HAVING   SELECT     FROM    WHERE      GROUP BY       HAVING      
LIKE    SELECT     FROM    WHERE     LIKE    

IN     SELECT     FROM    WHERE     IN ( ) 

BETWEEN    SELECT     FROM    WHERE     BETWEEN  1 AND  2 

IS NULL     SELECT     FROM    WHERE     IS NULL