How can i change the column name.
Answer Posted / kshirsagar sambhaji
ALTER TABLE table_name
RENAME COLUMN old_name to new_name;
| Is This Answer Correct ? | 3 Yes | 11 No |
Post New Answer View All Answers
Explain trigger and its types?
How does index makes search faster?
Write a query for primary key constraint with identity key word?
what is an extended stored procedure? Can you instantiate a com object by using t-sql? : Sql server database administration
Explain the properties of the relational tables?
What is the difference between ddl and dml?
What’s the distinction between dropping a info and taking a info offline?
In my application I have a process which picks the scanned files (tif format) from a shared location and it links to application and shown on it.The actuall issue is that my process picks the file before it is completly written or scanned which results in displaying few parts of the image or incomplete image.I need to check if the file is not completly scanned or written then do not link it to application.Please help if any body tell me that how can i check that file is in written phase or locked through DTS.thanking you in advance
Why we need to use secondry database file? though, we can do same work using primary database file also.
Do you know data definition language, data control language and data manipulation language?
What are the differences between local and global temporary tables?
Data table as parameter in sql server?
What are the advantages of passing name-value pairs as parameters?
How do clustered indexes store data?
IF more than one Site is accessing the same Database server and I want to move the DB with Minimum down time? How will you do