Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
raja.narina
Starting Member
6 Posts |
 Posted - 2011-01-06 : 04:47:19
|
| create table std(std_no int Not Null,std_name varchar(100),std_branch varchar(100),std_percentage int Not Null,std_status varchar(100)) iam trying that the above quiery in sql 2005 severbut it shows this......Msg 2714, Level 16, State 6, Line 1There is already an object named 'std' in the database.so plz send me reply plz.iam beginner to sql........N.S.Sitaram |
|
|
eljapo4
Posting Yak Master
100 Posts |
Posted - 2011-01-06 : 04:50:57
|
| Check the DB that you are trying to create this table on and see if the Table std already exists there |
 |
|
|
raja.narina
Starting Member
6 Posts |
Posted - 2011-01-06 : 04:59:19
|
| i have changed to so many names& also in database , but still shoing thi errorN.S.Sitaram |
|
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2011-01-06 : 05:09:59
|
| Have you looked for views? Views and tables can not have the same names...- LumbagoMy blog (yes, I have a blog now! just not that much content yet) -> www.thefirstsql.com |
|
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2011-01-06 : 05:10:47
|
| Or try this:SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'std'- LumbagoMy blog (yes, I have a blog now! just not that much content yet) -> www.thefirstsql.com |
|
|
|
|
|
|
hiiiiii