change table name in sql server 2000

[Amir.php]

How i can change name of an existing table in sql server 2000?
I mean from 'sql query analyzer', using command.
please suggest.

[Faun]

^lol at spammers outbreak !

[Milkshake]

^^I am NOT a spammer!!! i am trying to teach ppl about technology!!!

[Amir.php]

Originally Posted by T159

^lol at spammers outbreak !

what is your means?

[victor_rambo]

Originally Posted by Amir.php

what is your means?

I think his 'means' is that you are a spammer.

[Amir.php]

Originally Posted by victor_rambo

I think his 'means' is that you are a spammer.

i was just asking a problem, because i have not find any query related with my problem, because i have not find any satisfactory solution on books and google also.
The only thing i have find changing the column name of table, not table.
But sadly your and T159' s behaviour is very bad.
Also i am an old member of digit. Keep in your minds I does not support things like spamming etc.

[Faun]

^^sorry, it wasnt for you, it was the spam which mods deleted.

[QwertyManiac]

Aw, there was a spam post here Amir.php, and T159 was referring to its author (Milkshake).

Victor_rambo comes to quick conclusions, lol

[RChandan]

Right click on the table name on the tree in the object explorer, click Modify, and enter the new name in the properties page.

If you have foreign key constraints or other constraints which will break relationships with other dependant tables, this will not be allowed.