'This method creates a new SQL Server database Listing 2 creates a SQL Server database mydb and data files are stored in the C:\mysql directory. Depending on the database type, you can also set values of database size, growth and file name. The syntax of CREATE DATABASE depends on the database you create. The CREATE DATABASE SQL statement creates a database.

If conn.State = ConnectionState.Open ThenĬonnectionString = 'Integrated Security=SSPI ' + 'Initial Catalog=mydb ' + 'Data Source=localhost 'Īfter this I'm going to create a new SQL Server database. Private Sub ExecuteSQLStmt( ByVal sql As String) Our application form looks like Figure 1. You can even test code by adding only one button or one button for each activity. To test this application, create a Widows application add a data grid control and some button controls.

In this application, I'll create a SQL Server database, create a database table, add data to it, create database objects such as views, stored procedures, rules, and index and view data in the data grid using Sql data provider. This example shows you how to create a new database table, add data to it, create a view of the data, alter database table and then delete the newly created table. It also provides commands to alter a database and database schemas for example adding and deleting a column from a database table, adding some constraints to a column and so on. Using SQL statements you can create database objects programmatically such as a table, view, stored procedure, rule, index and so on. SQL not only let you select, add, and delete data from databases table, it also provides commands to manage databases.

Sql server create table