dimanche 3 juillet 2016

Convert SnakeCase DDL to PascalCase for table and columns


Convert SnakeCase Db sql to PascalCase for Table and Columns. IS there a best way to do it ? Example of snakeCase below is in MYSQL and converted to MSSQL.

DROP TABLE IF EXISTS `addresses`;
CREATE TABLE `addresses` (
  `id` int(11) NOT NULL default '0',
  `line1` varchar(255) default NULL,
  `line2` varchar(255) default NULL,
  `city` varchar(255) default NULL,
  `state` varchar(35) default NULL,
  `zip` varchar(10) default NULL,
  `plus_four` varchar(4) default NULL,
  `country` varchar(255) default NULL,
  `foreign_id` int(11) default NULL,
  PRIMARY KEY  (`id`),
  KEY `foreign_id` (`foreign_id`)
) ENGINE=InnoDB;

Want to Convert it to

CREATE TABLE [dbo].[Company](
    [CompanyKey] [nvarchar](15) NOT NULL,
    [Name] [nvarchar](50) NULL,
 CONSTRAINT [PK_Company] PRIMARY KEY CLUSTERED 
(
    [CompanyKey] ASC
)

Aucun commentaire:

Enregistrer un commentaire