Can we use Multiple tables from Multiple databases in a same query?

Yes. We can do it by writing fully qualified names. The full name of a table is made up of Server name Database name Schema name Table name The full name of a table: Server name.Database name.Schema name.Table name This is known

Read More

What are the Properties of Relational Tables?

Properties: All the values should be Atomic Each Column must have a unique name in the table All the Rows must be Unique All the values of a column are of same kind Ordering of columns is not necessary(doesn’t matter) Ordering of

Read More