Skip to content

Instantly share code, notes, and snippets.

@goyalmohit

goyalmohit/create-table-and-populate-data-2

Created March 9, 2019 14:23
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save goyalmohit/a29ca3a587ea39d3d348d36da7a2d628 to your computer and use it in GitHub Desktop.
Save goyalmohit/a29ca3a587ea39d3d348d36da7a2d628 to your computer and use it in GitHub Desktop.
Download ZIP
Create table and populate data along with rollback statements using liquibase
Raw
create-table-and-populate-data-2
-- liquibase formatted sql
-- changeset mohitgoyal:20190309122800
CREATE TABLE [dbo].[CustomerDetails5](
[CustomerTypeID] [nchar](10) NULL,
[CustomerDesc] [nvarchar](max) NULL,
[CustomerAddress] [varchar](255) NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
--rollback DROP TABLE [dbo].[CustomerDetails5]
-- changeset mohitgoyal:20190309175300
insert into CustomerDetails5 values ('A','CustomerA','SanDiego')
insert into CustomerDetails5 values ('A','CustomerB','Miami')
-- rollback delete from CustomerDetails5
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment