Monday 27 February 2017

Rename table in sql server

One of the important interview question in Dotnet.
 how to change table name in SQL server
Syntax:
Sp_rename 'oldtablename','newtablename';

Example:
Sp_rename 'emp','employee';

5 comments:

  1. Really a good technical site,keep on writing good stuffs
    dot net training in chennai

    ReplyDelete
  2. best site please post new articles

    ReplyDelete
  3. Pdf download using asp.net....
    http://www.dotnetawesome.com/2014/02/how-to-export-database-data-to-pdf-file-using-aspnet.html

    ReplyDelete