Skip to content

Instantly share code, notes, and snippets.

@goyalmohit

goyalmohit/create-and-populate-table-with-liquibase

Created March 9, 2019 13:57
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save goyalmohit/9c11206b1ed9acbbf746ccfc18467e71 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save goyalmohit/9c11206b1ed9acbbf746ccfc18467e71 to your computer and use it in GitHub Desktop.
Download ZIP
Create and Populate Table using Liquibase
Raw
create-and-populate-table-with-liquibase
-- liquibase formatted sql
-- changeset mohitgoyal:20190309122800
CREATE TABLE [AdventureWorks2017].[dbo].[CustomerDetails5](
[CustomerTypeID] [nchar](10) NULL,
[CustomerDesc] [nvarchar](max) NULL,
[CustomerAddress] [varchar](255) NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
--rollback drop table CustomerDetails5
-- changeset mohitgoyal:20190309175300
insert into CustomerDetails5 values ('A','CustomerA','SanDiego')
insert into CustomerDetails5 values ('A','CustomerB','Miami')
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment