In my project i want to create a database through my application, how can create new database using sql statement.( i.e create database...)
bnitishpai 0 Newbie Poster
Ancient Dragon 5,243 Achieved Level 70 Team Colleague Featured Poster
bnitishpai 0 Newbie Poster
Thanks, but I have more. How to set the filepath for that database?
ChrisHunter 152 Posting Whiz in Training Featured Poster
Can you be a bit clearer please @bnitishpai
Do you want to know how create a DB using a language like C# or Java in Visual Studios rather than straight in SQL Server Management Studios, if so what language are you using?
ChrisHunter 152 Posting Whiz in Training Featured Poster
Can you be a bit clearer please @bnitishpai
Do you want to know how create a DB using a language like C# or Java in Visual Studios rather than straight in SQL Server Management Studios, if so what language are you using?
Ancient Dragon 5,243 Achieved Level 70 Team Colleague Featured Poster
What database server are you using? Most of them don't let you change the path, it's established when the database server is installed. And after thinking about it I don't think you can create a new database via programming languages because the language has to have a connection to an existing database in order to run sql commands.
ChrisHunter 152 Posting Whiz in Training Featured Poster
@Ancient Dragon, I think you're right about not being able to establish a DB through languages like C#, i tried it a while ago (I wanted to open and run an SQL file with a DB creation script in when a program is run for the first time) but there had to be a connection to a server already established before the script to create the DB could be run.
adam_k 239 Master Poster
If you have an sa account you can login to master db and create a new one.
Ancient Dragon 5,243 Achieved Level 70 Team Colleague Featured Poster
They can also be created using stored procedures, assuming you have the permissions to do that.
pssingh1001 0 Newbie Poster
Hi Dear;
How to create database in sql server ;
Sql is the Structured querie Language ... & the queries command is......
create database databasename;
this is the database creation command ;
regards
prem
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.