Write the syntax to rename a column to existing table ?
please give right answer
Share
Write the syntax to rename a column to existing table ?
please give right answer
Sign Up to our social questions and Answers Engine to ask questions, answer people’s questions, and connect with other people.
Login to our social questions & Answers Engine to ask questions answer people’s questions & connect with other people.
sǫʟ ʀᴇɴᴀᴍᴇ ᴄᴏʟᴜᴍɴ sʏɴᴛᴀx
ᴀʟᴛᴇʀ ᴛᴀʙʟᴇ "ᴛᴀʙʟᴇ_ɴᴀᴍᴇ" ᴄʜᴀɴɢᴇ "ᴄᴏʟᴜᴍɴ 1" "ᴄᴏʟᴜᴍɴ 2" ["ᴅᴀᴛᴀ ᴛʏᴘᴇ"];
ᴀʟᴛᴇʀ ᴛᴀʙʟᴇ "ᴛᴀʙʟᴇ_ɴᴀᴍᴇ" ʀᴇɴᴀᴍᴇ ᴄᴏʟᴜᴍɴ "ᴄᴏʟᴜᴍɴ 1" ᴛᴏ "ᴄᴏʟᴜᴍɴ 2";
ᴀʟᴛᴇʀ ᴛᴀʙʟᴇ ᴄᴜsᴛᴏᴍᴇʀ ᴄʜᴀɴɢᴇ ᴀᴅᴅʀᴇss ᴀᴅᴅʀ ᴄʜᴀʀ(50);
ᴀʟᴛᴇʀ ᴛᴀʙʟᴇ ᴄᴜsᴛᴏᴍᴇʀ ʀᴇɴᴀᴍᴇ ᴄᴏʟᴜᴍɴ ᴀᴅᴅʀᴇss ᴛᴏ ᴀᴅᴅʀ;
__________________
✰ᴍᴀʀᴋ ᴀs ʙʀᴀɪɴʟᴇᴀsᴛ✔︎