To rename a table in sql server, you just need a single line of code mentioned below:
sp_rename 'Old_table_name', 'New_table_name';
Just run the above query and the magic will happen.
Please make sure you change the table name every like stored procedure,views etc where you have used...
Widgets
Social Links
Search
Popular Posts
-
This post for those who are facing the problem of screen resolution and unable to locate the package virtualbox-guest-x11 Follow the belo...
-
In the fast-paced world of engineering, striking a balance between work and personal life can sometimes feel like navigating a complex algor...
-
By using the following command in sql server, you are able to find out the foreign key constraint references. SELECT OBJECT_NAME...
-
# Created by https://www.gitignore.io ### VisualStudio ### ## Ignore Visual Studio temporary files, build results, and ## files generated ...
-
Today i m going to show you how to configure DNS server in packet tracer.
-
To rename a table in sql server, you just need a single line of code mentioned below: sp_rename 'Old_table_name', 'New_tabl...
-
Step 1: Create a .htaccess file in the root directory of your project. Step2: Paste the following code to that file and save ...
-
In windows 10, Microsoft removed the ability to turn off automatic updates. the registry setting that allowed you to disable windows update...
-
Insert Command for Database are following below: INSERT INTO table_name(column1,column2,....) VALUES(value1,value2,.....);
-
How interesting it is right? yes! you can create your own run command for your windows. Please go Through the following step: 1....
