contestada

write and execute an sql create table statement in ssms to create the customer 01 table. (provide the select statement script and screenshot of the execute/output from the select/script statement and paste below for this question.)\

Respuesta :

Written a program for execute an sql  create table statement in ssms to create the customer 01 table

Use of a two-part name is required to create a table in a particular schema in sql . The database must contain the schema for which the table is being created. For instance, if you want to create a table called tblPatient in the Patients schema, the definition for creating the table will look like this:

CREATE TABLE [customer ].[01 table](

   [customer _ID] [bigint] IDENTITY(1,1),

   [customer t_code] [varchar](50),

   [customer _name] [varchar](50),

   [Address] [varchar](25),

   [City] [varchar](50),

   [AppointmentDate] [datetime],

 ) ON [PRIMARY]

To create a new table in a database, use the CREATE TABLE statement. We must include the filegroup name in the CREATE TABLE statement in order to create a table in the secondary filegroup. Ensure that the database already contains the filegroup in which you are creating the table. When you want to keep your frequently accessed tables on a different disk, creating a table in a secondary filegroup can be helpful.

Learn more about sql here:

https://brainly.com/question/13068613

#SPJ4

Otras preguntas