Rename Table Name

Suppose your table is alertclub and you will change it to AC

Step 1: Execute this query:

EXEC sp_rename 'alertclub', 'AC'

 After execute this query, one msg will come out like this:

Caution: Changing any part of an object name could break scripts and stored procedures.

Step 2: select * from AC 

Table name raname from alertclub to AC