Sqlserver Interview questions


Total available count: 45
Subject - Databases
Subsubject - Sqlserver

After a table is defined, can columns be removed?

The only method to remove columns from an existing table involves a migration program that extracts only the desired columns of data, redefining the table without the unwanted columns, then populating the new table. One has to handle all the old table’s dependents programmatically. 




Next 5 interview question(s)

1
Can one add columns to a table after it has been defined?
2
What is the syntax for a CREATE TABLE statement?
3
What RDMS objects are required before you can create a table?
4
What RDMS objects are created with the SQL CREATE statements?
5
How many types of Joins in SQL Server?