Rename table column name using SP_Rename system stored procedureīelow is the SYNTAX of the SP_RENAME system stored procedure for renaming the column name: Create Procedure to get all the records from customer table INSERT INTO dbo.Customer(id, CustName, ]], Add sample records to the Customer table To understand table column rename using SP_RENAME with extensive list of examples, let us first create a Customer table with sample records as depicted in the below image by using the following script:ĬREATE TABLE dbo.Customer(Id INT, CustName NVARCHAR(50),
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |