I want to reuse the structure of a database in a new project. So using **SSMS** I use **Generate Script** and in settings I set to generate **schema only**.
In the result there are too many queries about extendedproperty. Is there any important data or settings in these queries or I can completely **igonre** them and only reuse queries on database tables and fields to start a similar project?
And if they ar unnecessary how can I use **"generate script"** without them?
sample query:
EXEC sys.sp_dropextendedproperty @name=N'CollatingOrder' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'billboard', @level2type=N'COLUMN',@level2name=N'url'
Asked by Ali Sheikhpour
(231 rep)
Dec 31, 2018, 09:06 PM
Last activity: Jan 1, 2019, 11:10 AM
Last activity: Jan 1, 2019, 11:10 AM