Question

Write the syntax to rename a column to existing table ?




please give right answer​

Answer 1

• sǫʟ ʀᴇɴᴀᴍᴇ ᴄᴏʟᴜᴍɴ sʏɴᴛᴀx

1. ᴀʟᴛᴇʀ ᴛᴀʙʟᴇ "ᴛᴀʙʟᴇ_ɴᴀᴍᴇ" ᴄʜᴀɴɢᴇ "ᴄᴏʟᴜᴍɴ 1" "ᴄᴏʟᴜᴍɴ 2" ["ᴅᴀᴛᴀ ᴛʏᴘᴇ"];
2. ᴀʟᴛᴇʀ ᴛᴀʙʟᴇ "ᴛᴀʙʟᴇ_ɴᴀᴍᴇ" ʀᴇɴᴀᴍᴇ ᴄᴏʟᴜᴍɴ "ᴄᴏʟᴜᴍɴ 1" ᴛᴏ "ᴄᴏʟᴜᴍɴ 2";
3. ᴀʟᴛᴇʀ ᴛᴀʙʟᴇ ᴄᴜsᴛᴏᴍᴇʀ ᴄʜᴀɴɢᴇ ᴀᴅᴅʀᴇss ᴀᴅᴅʀ ᴄʜᴀʀ(50);
4. ᴀʟᴛᴇʀ ᴛᴀʙʟᴇ ᴄᴜsᴛᴏᴍᴇʀ ʀᴇɴᴀᴍᴇ ᴄᴏʟᴜᴍɴ ᴀᴅᴅʀᴇss ᴛᴏ ᴀᴅᴅʀ;

__________________

✰ᴍᴀʀᴋ ᴀs ʙʀᴀɪɴʟᴇᴀsᴛ✔︎

Answer 2

sǫʟ ʀᴇɴᴀᴍᴇ ᴄᴏʟᴜᴍɴ sʏɴᴛᴀx

ᴀʟᴛᴇʀ ᴛᴀʙʟᴇ "ᴛᴀʙʟᴇ_ɴᴀᴍᴇ" ᴄʜᴀɴɢᴇ "ᴄᴏʟᴜᴍɴ 1" "ᴄᴏʟᴜᴍɴ 2" ["ᴅᴀᴛᴀ ᴛʏᴘᴇ"];

ᴀʟᴛᴇʀ ᴛᴀʙʟᴇ "ᴛᴀʙʟᴇ_ɴᴀᴍᴇ" ʀᴇɴᴀᴍᴇ ᴄᴏʟᴜᴍɴ "ᴄᴏʟᴜᴍɴ 1" ᴛᴏ "ᴄᴏʟᴜᴍɴ 2";

ᴀʟᴛᴇʀ ᴛᴀʙʟᴇ ᴄᴜsᴛᴏᴍᴇʀ ᴄʜᴀɴɢᴇ ᴀᴅᴅʀᴇss ᴀᴅᴅʀ ᴄʜᴀʀ(50);

ᴀʟᴛᴇʀ ᴛᴀʙʟᴇ ᴄᴜsᴛᴏᴍᴇʀ ʀᴇɴᴀᴍᴇ ᴄᴏʟᴜᴍɴ ᴀᴅᴅʀᴇss ᴛᴏ ᴀᴅᴅʀ;

__________________

✰ᴍᴀʀᴋ ᴀs ʙʀᴀɪɴʟᴇᴀsᴛ✔︎