| Author |
Topic |
|
charles1309
Starting Member
15 Posts |
 Posted - 2007-11-20 : 12:57:10
|
| anyone know how to drop my databse on sql pleaseecharles |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
Zoroaster
Aged Yak Warrior
702 Posts |
Posted - 2007-11-20 : 13:00:38
|
Look it up in books online, click on index and type in drop database it will tell you all you need to know about it.
Future guru in the making. |
 |
|
|
charles1309
Starting Member
15 Posts |
Posted - 2007-11-20 : 18:26:07
|
| how do i know what is the name of the databse brettcharles |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-11-20 : 19:01:11
|
quote:
Originally posted by charles1309
how do i know what is the name of the databse brettcharles
If you don't know that answer, then you should not be dropping the database. Contact someone else in your organization with more experience to assist you with this.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
Butterfly82
Starting Member
30 Posts |
Posted - 2007-11-20 : 19:30:45
|
| Yeah, it's a little worrying that you don't know the name of the database. One way you could identify the DB name though is through using Query Analyzer or SSMS. Locate the DB that has the tables (assuming you know the tables) that are in the DB you are looking for using the Object Explorer panel. Hopefully you don't have many databases, if so this method could take some time.I agree with tkizer, though it seems like this is for learning purposes. I would still make a backup of it to be safe. Keep in mind that dropping a database erases everything within it, its tables, data etc.Hope this helpsButterfly82 |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2007-11-21 : 00:54:09
|
quote:
Originally posted by charles1309
how do i know what is the name of the databse brettcharles
Wont you make use of sql server help file?Read about name of database thereMadhivananFailing to plan is Planning to fail |
|
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2007-11-21 : 07:46:35
|
quote:
Originally posted by charles1309
how do i know what is the name of the databse brettcharles
This is how we do it in MS SQL Server.select db_name()
KH[spoiler]Time is always against us[/spoiler] |
|
|
|
Butterfly82
Starting Member
30 Posts |
Posted - 2007-11-21 : 10:07:16
|
quote:
Originally posted by khtan
This is how we do it in MS SQL Server.select db_name()
Or you could do it this way  I'm learning all the time! |
|
|
|
|
drop database