Ans:
sp_rename oldtablename newtablename
For changing the column name
Sp_rename ‘tablename.[Oldcolumnname]’,’newcolumnname’,’Column’
Ex:sp_rename ‘tblemp.first’,’namechange’,’Column’
Subscribe to:
Post Comments (Atom)
Enter Your Question
Tag
Total Pageviews
Blog
-
▼
2013
(88)
-
▼
November
(84)
- Why should we use separate ASM home?
- How does one list the partitions of a partitioned ...
- How do I know if an object is partitioned or not?
- How does one enable partition support for a database?
- What is an integrity constraint?
- Explain various types of constraints in Oracle.
- Explain the constraints that can be applied to Ora...
- What is a LOB data type?
- Explain BLOB, CLOB, NCLOB and BFILE.
- Explain the differences between char and varchar2 ...
- Explain the types of Exceptions.
- Explain the guidelines for Avoiding and Handling P...
- How PL/SQL Exceptions Are Raised?
- Explain user defined exceptions in oracle.
- What are the predefined oracle exceptions?
- What is Exception in Oracle?
- What are SQL functions in oracle?
- What is NVL function?
- What is nested function?
- What are conversion functions?
- What are the rules of writing package?
- Explain IN, OUT and INOUT in procedures.
- What is correlated sub-query?
- What are the guidelines for using SUB-QUERIES?
- What are the different operators used in building ...
- Explain sub-queries in brief.
- Difference between database triggers and form trig...
- What are the types of triggers and how the sequenc...
- Explain the different types of trigger in oracle.
- Difference between database triggers and form trig...
- What are triggering attributes?
- How the triggers are attached to the table?
- What is Varrays?
- What are cascading triggers?
- Advantage of a stored procedure over a database tr...
- Explain Row level and statement level trigger.
- Disadvantages of trigger in oracle.
- What are the types of triggers?
- What is trigger in oracle?
- What happens when I enter a URL in my browser and ...
- What is static keyword in .Net?
- What is the Difference between read only and const...
- What is the difference between view state and hidd...
- How many web.config files are there in 1 project?
- What is the difference between Primary key and uni...
- What is Collation?
- What is the difference between .tostring(), Conver...
- What are the thread priority levels?
- What is synchronization?
- What is the serialization?
- What is the location of Global Assembly Cache on t...
- How to get the version of the assembly?
- What is the difference between authorization and a...
- What is the difference between application excepti...
- When should you use Abstract Class vs Interface wh...
- What is the cross page post backing?
- What is difference between constants, read-only an...
- What is a Partial class?
- What is dll hell problem in .NET and how it will s...
- What do you mean by String objects are immutable?
- What are the different levels of State management ...
- If I write System.exit (0); at the end of the try ...
- What is the difference Grid View and between Data ...
- What are difference between truncate and delete?
- What are difference between GET and POST Methods?
- What is the difference between scope_identity() an...
- Can you write the program to find the length of st...
- How to find out which index is defined on table?
- How to change the name of the table or stored proc...
- Can we change the index of primary key on table?
- Write a sample query for self join?
- Why we go for page rendering in Asp.Net Page life ...
- What are the differences between value type and re...
- What is boxing and unboxing concepts in .net?
- What is the difference between primary key and uni...
- What are the differences between Abstract and inte...
- What are differences between function and stored p...
- Is it possible to set the session out time manually?
- How many types of memories are there in .net?
- What are the differences between Application objec...
- What are differences between system.stringbuilder ...
- What are differences between Array list and Hash t...
- Difference between Abstract and Interface
- Difference between stored procedure and function
-
▼
November
(84)
No comments:
Post a Comment