From the daily archives: Friday, August 19, 2011
The CREATE DATABASE SQL statement is part of the Data Definition Language (DML) defined by Codd and is used define (CREATE), modify (ALTER) or remove (DROP) databases along with there associated files.
Before I talk about crafting a database, I want to classify SQL statements by four known groups.
Categories
- Database Admin (39)
- Database Developer (76)
- Integration Services (5)
- Other (11)
- Perl Scripting (7)
- SQL Pass Events (7)
- SQL Tidbits (24)
- Under Construction (1)
- VB Script (10)
Cloud Tags
AFTER ALTER TABLE ALTER TRIGGER CPAN perl modules CREATE DATABASE create function CREATE FUNTION create procedure CREATE TABLE create trigger create view database administrator database developer DATA TYPES DDL DECLARE DELETE DROP DATABASE DROP TRIGGER DROP VIEW execute EXISTS FORMAT free code INSERT ISNULL John F. Miner III perl script REPLACE SELECT sp_help sp_helptext SQL Server SQL Server Management Studio SSMS. string function sys.databases sys.objects sys.schemas TRIGGERS TRUNCATE TABLE TSQL UPDATE USER DEFINED VIEW vb script
