
{filelink=16152}
using System;
using System.Data;
using System.Data.SqlClient;
class CreationTable {
public static void Main() {
SqlConnection connexion =new SqlConnection(@"server=(local);database=MesExemples.com;Integrated Security=SSPI;");
SqlCommand commandeSQL = connexion.CreateCommand();
// Création de la table Utilisateur
commandeSQL.CommandText =
"CREATE TABLE Utilisateur (" +
" ID int CONSTRAINT PK_Persons PRIMARY KEY," +
" Nom nvarchar(15) NOT NULL," +
" Prenom nvarchar(15) NOT NULL," +
" email nvarchar(15) NOT NULL," +
" DateDeNaissance datetime" +
")";
connexion.Open();
Console.WriteLine("Création de la table Utilisateur");
int result = commandeSQL.ExecuteNonQuery();
Console.WriteLine("Résultat d'exécution: " + result);
connexion.Close();
}
}