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
