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