• CONTEST ALERT - Experience the power of DDR5 memory with Kingston Click for details

change table name in sql server 2000

Not open for further replies.


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


Flying Visitor
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.


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

Victor_rambo comes to quick conclusions, lol :))


Broken In
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.
Not open for further replies.
Top Bottom