While installing solidworks PDM Standard, does SQL server needs to be installed only as mentioned in installation guide or needs creation of any tables in the database?
SQL Server Express will get installed during the install unless you already have it installed. All of the databases, tables, stored procedures, etc. will get created and managed by the PDM software. You don't need to do anything for that portion of the setup.
Retrieving data ...