Odata creata baza de date vom trece la pasul urmator, si anume crearea de tabele in cadrul acesteia.
Primul tabel creat se va numi: Studenti.
Un tabel se poate crea in doua moduri:
1. Prin interfata grafica:
In Object Explorer, mergem la baza noastra de date, dam click dreapta pe Tables - > New Table si vom introduce coloanele tabelei noastre.
Aici vom introduce un nou concept: cheia primara. Cheia primara a unui tabel este cea care identifica in mod unic o inregistrare din cadrul acestuia. In exemplul nostru vom folosi un camp de tip integer care se va autoincrementa la fiecare adaugare de inregistrare noua. Astfel vom da click pe IDStudent iar in partea stanga sus avem o pictograma cu o cheie galbena pe care o vom selecta, iar pentru a ne seta incrementarea pe cheie mergem in josul paginii la Column Properties -> Identity Specification-> Identity Increment – > YES.
Tot ce ne mai ramane acum de facut este sa salvam tabelul.
2. Prin linie de cod:
1 2 3 4 5 6 7 |
<span class="SQLKeyword" style="color: #0000aa;">CREATE</span> <span class="SQLKeyword" style="color: #0000aa;">TABLE</span> dbo<span class="SQLOperator" style="color: #777777;">.</span>Studenti <span class="SQLOperator" style="color: #777777;">(</span> IDstudent <span class="SQLKeyword" style="color: #0000aa;">INT</span> <span class="SQLOperator" style="color: #777777;">NOT</span> <span class="SQLKeyword" style="color: #0000aa;">NULL</span> <span class="SQLFunction" style="color: #aa00aa;">IDENTITY</span><span class="SQLOperator" style="color: #777777;">(</span>1<span class="SQLOperator" style="color: #777777;">,</span> 1<span class="SQLOperator" style="color: #777777;">)</span> <span class="SQLOperator" style="color: #777777;">,</span>Nume <span class="SQLKeyword" style="color: #0000aa;">NVARCHAR</span><span class="SQLOperator" style="color: #777777;">(</span>50<span class="SQLOperator" style="color: #777777;">)</span> <span class="SQLOperator" style="color: #777777;">NOT</span> <span class="SQLKeyword" style="color: #0000aa;">NULL</span> <span class="SQLOperator" style="color: #777777;">,</span>Prenume <span class="SQLKeyword" style="color: #0000aa;">NVARCHAR</span><span class="SQLOperator" style="color: #777777;">(</span>50<span class="SQLOperator" style="color: #777777;">)</span> <span class="SQLOperator" style="color: #777777;">NOT</span> <span class="SQLKeyword" style="color: #0000aa;">NULL</span> <span class="SQLOperator" style="color: #777777;">,</span>Data_nasterii <span class="SQLKeyword" style="color: #0000aa;">DATETIME</span> <span class="SQLOperator" style="color: #777777;">NOT</span> <span class="SQLKeyword" style="color: #0000aa;">NULL</span> <span class="SQLOperator" style="color: #777777;">,</span>Localitate <span class="SQLKeyword" style="color: #0000aa;">NVARCHAR</span><span class="SQLOperator" style="color: #777777;">(</span>50<span class="SQLOperator" style="color: #777777;">)</span> <span class="SQLOperator" style="color: #777777;">NOT</span> <span class="SQLKeyword" style="color: #0000aa;">NULL</span> <span class="SQLOperator" style="color: #777777;">)</span> <span class="SQLKeyword" style="color: #0000aa;">ON</span> [PRIMARY] |