Home
Recent Q&A
Feedback

what is the command to alter the structure of the table?

Home
DBMS
what is the command to alter the structure of the table?

asked Oct 30, 2019 in DBMS by rajeshsharma

Q:

what is the command to alter the structure of the table?

alter-statement

Answer

1 Answer

0 votes

answered Oct 30, 2019 by SakshiSharma

the definition of the existing relation can be altered by using ALTER

statement.this statement allows a new column to be added to an existing

relation.

Click here to read more about Loan/Mortgage

Click here to read more about Insurance

Facebook Twitter LinkedIn

Related questions

0 votes

Q: what is the command to alter table values in SQL?

asked Oct 30, 2019 in DBMS by rajeshsharma

sql-command

0 votes

Q: How will you rename a table in Hive without using ALTER command?

asked Jan 12, 2020 in Big Data | Hadoop by sharadyadav1986

#hive-alter-commands

0 votes

Q: what is the command to delete a table in SQL

asked Oct 30, 2019 in DBMS by rajeshsharma

sql-delete-table
sql-table

0 votes

Q: what is the command to delete a record in the table?

asked Oct 30, 2019 in DBMS by rajeshsharma

sql-command
sql-delete

0 votes

Q: An SQL query to delete a table from the database and memory while keeping the structure of the table intact?

asked Dec 15, 2020 in Sql by SakshiSharma

#sql-delete
#delete-database

0 votes

Q: Hive - Alter Table

asked Sep 7, 2019 in Big Data | Hadoop by john ganales

#hadoop
#hadoop-live
#pig-hadoop
#hadoop-tutorials
#hadoop-architecture
#hadoop-certification
#spark-hadoop
#hadoop-cluster
#what-is-hadoop
#apache-hadoop
#big-data-hadoop
#what-is-yarn-in-hadoop
#yarn-hadoop
#hadoop-vs-spark

0 votes

Q: How to create empty tables with the same structure as another table?

asked Dec 15, 2020 in Sql by SakshiSharma

#empty-tables
#table-structure

0 votes

Q: What can be altered using ALTER command?

asked Jan 31, 2020 in Cassandra by MBarbieri

#cassandra-alter

0 votes

Q: Using the ALTER DATABASE command in an database you can change the

asked Apr 3, 2020 in Big Data | Hadoop by Tate

0 votes

Q: DBMS Reduction of ER diagram to Table

asked Oct 27, 2019 in DBMS by rajeshsharma

dbms-er-diagram

0 votes

Q: What command is used to delete the table

asked Jan 15 in Cassandra by SakshiSharma

truncate

0 votes

Q: What command is used to delete all the rows in a table

asked Jan 15 in Cassandra by SakshiSharma

truncate

0 votes

Q: What command is used to delete the table?

asked Jan 15 in Cassandra by SakshiSharma

#cassandra-delete-table
#table-delete

0 votes

Q: What command is used to delete all the rows in a table?

asked Jan 15 in Cassandra by SakshiSharma

#cassandra-delete-row
#delete-row-command

0 votes

Q: What is Test Discovery and what is command structure in Python?

asked Jun 30, 2020 in Python by GeorgeBell

#python

0 votes

Q: what is the command to insert a record in SQL

asked Oct 30, 2019 in DBMS by rajeshsharma

sql-insert

0 votes

Q: To see the partitions present in a Hive table the command used is

asked Apr 3, 2020 in Big Data | Hadoop by Tate

0 votes

Q: Give a command to check if a table is disabled in HBase

asked Jun 10, 2020 in HBase by Robindeniel

#hbase-table-disable

0 votes

Q: Give a command to store 4 versions in a table rather than the default 3.

asked Jun 13, 2020 in HBase by Robindeniel

#hbase-4-version

+1 vote

Q: nrows and skip arguments in the read.table() command can be used to get

asked May 27, 2019 in Data Handling by tempuser

#datahandling

0 votes

Q: What is column families? What happens if you alter the block size of ColumnFamily on an already populated database?

asked Jan 26, 2020 in Big Data | Hadoop by rajeshsharma

#coloumn-families

0 votes

Q: What is the use of TOUCH in ALTER statement?

asked Jan 12, 2020 in Big Data | Hadoop by sharadyadav1986

#hive-touch
#hive-alter

0 votes

Q: what is a table in DBMS?

asked Oct 30, 2019 in DBMS by rajeshsharma

dbms-table
table-dbms

+1 vote

Q: What is Stop command for DB2 Server?

asked Aug 21, 2020 in DBMS by DavidAnderson

#db2

0 votes

Q: LOAD DATA INPATH into table <tablename>; In this command, where will Hive search for a file?

asked Apr 1, 2020 in Big Data | Hadoop by AdilsonLima

#hive-view

0 votes

Q: In this command, where will Hive search for a file? LOAD DATA INPATH into table < tablename>;

asked Jan 31, 2020 in Cassandra by MBarbieri

#cassandra-table

0 votes

Q: Which of the following models would be most useful in helping to define an organisational structure?

asked Feb 14, 2020 in Agile by matthenary

+1 vote

Q: How to see the Structure (Schema) of the DataFrame

asked Jun 30, 2019 in Spark Sql by anonymous

#spark-sql-questions-answers
#spark-sql
#spark-sql-questions
#sql-faq
#spark-sql-faq
#hadoop
#hadoop-spark
#big-data
#sql-tutorial

0 votes

Q: What is the method to save data in a stack data structure type?

asked Mar 17, 2020 in C Plus Plus by SakshiSharma

#c-language-stack-data

0 votes

Q: How to find structure of a dataframe

asked Jun 6, 2019 in Data Handling using R by tempuser

#datahandling

About us

Subscribe Us

HOT LINKS

Data Visualisation Aurora

Hadoop and Big Data

TRANDING TECHNOLOGIES

CONTACT US

New York, NY 10012, US

[email protected]

Follow us on Social Media

Send feedback

© Copyright 2018-2020 www.madanswer.com. All rights reserved. Developed by Madanswer.

...