Data Definition Language in SQL

1
SQL DDL

• Data Definition Language in SQL

2
(No Transcript)
3
(No Transcript)
4
(No Transcript)
5
(No Transcript)
6
(No Transcript)
7
(No Transcript)
8
(No Transcript)
9
(No Transcript)
10
(No Transcript)
11
(No Transcript)
12
Data types
BLOB binary large object
13
(No Transcript)
14
(No Transcript)
15
(No Transcript)
16
(No Transcript)
17
(No Transcript)
18
(No Transcript)
19
(No Transcript)
20
(No Transcript)
21
(No Transcript)
22
(No Transcript)
23
(No Transcript)
24
(No Transcript)
25
(No Transcript)
26
(No Transcript)
27
(No Transcript)
28
(No Transcript)
29
(No Transcript)
30
(No Transcript)
31
(No Transcript)
32
(No Transcript)
33
(No Transcript)
34
(No Transcript)
35
(No Transcript)
36
(No Transcript)
37
(No Transcript)
38
CREATE database script file

• -- This will create the database 's1234567'for a
  user with ID 'SDSMT\1234567'
• CREATE DATABASE s1234567
• ON PRIMARY
• (NAME s1234567,
• FILENAME 'C\program files\microsoft sql
  server\mssql\data\s1234567.mdf',
• SIZE 2, MAXSIZE 10, FILEGROWTH 2)
• GO
• -- This will create the SQL Logins for a student
• EXEC sp_grantlogin 'SDSMT\1234567'
• GO
• -- This will grant the Login access to the
  database 's1234567' and make the student a member
• -- of the 'public' database role
• USE s1234567
• GO
• EXEC sp_grantdbaccess 'SDSMT\1234567'
• GO