Question

$\huge\bigstar\underline\mathfrak{Question:-}$

1.How to list out all database.


2.How to select a database with name student.


3. How to list out all table.


4. Create a table name called 'shop' which consists of three column.

•Product ID

•Product name

•Data purchase


Answer all the question ⬆️⬆️⬆️⬆️⬆️​

Answer 1

Answer:

1). To view a list of databases on an instance of SQL Server

• In Object Explorer, connect to an instance of the SQL Server Database Engine, and then expand that instance.
• To see a list of all databases on the instance, expand Databases. $\:$

2). When you have multiple databases in your SQL Schema, then before starting your operation, you would need to select a database where all the operations would be performed. The SQL USE statement is used to select any existing database in the SQL schema.

$\: \:$

3). The easiest way to see all tables in the database is to query the all_tables view: SELECT owner, table_name FROM all_tables; This will show the owner (the user) and the name of the table. You don't need any special privileges to see this view, but it only shows tables that are accessible to you.

$\: \:$

Answer 2

$\huge\bigstar\underline\mathfrak{Answer-}$

1.

• In Object Explorer, connect to an instance of the SQL Server Database Engine, and then expand that instance.

• To see a list of all databases on the instance, expand Databases.

2.

[tex]\huge\fbox\pink{select}[/tex]

column_name1,

column_name2,

column_name3,

...

column_nameN

$\huge\fbox\pink{From}$ table_name;

$\huge\fbox\pink{Example}$

s_id name age address

address190 Bhumika 13 Delhi.

191 Jagdeep 16 Punjab.

192 Rahul 18 Kolkata.

193 Anisha 15 Utrakhand.

3.

SELECT owner, table_name FROM all_tables; This will show the owner (the user) and the name of the table. You don't need any special privileges to see this view, but it only shows tables that are accessible to you.

4.

U can do the answer by seeing 2 no. .......