SQL Server is a relational model database and as we know administrators use T-SQL and ANSI SQL as their primary query languages. Talking of ALTER TABLE, this statement enables a user to rename an existing table. Moreover, this statement can be successfully used to add, modify or drop a column read more...