No, it's a good question.

You could look after:

• If there are som diagrams under the 'Database Diagrams' node in SSMS
• If tables and columns have Extended Properties.

You need char(11).
select convert(char(11), getdate(), 100) as DefaultDateFormat;
See https://docs.microsoft.com/en-us/sql/t-sql/functions/cast-and-convert-transact-sql

Nice,
Also add schema, first in select
"Schema" = object_schema_name(Obj.object_id),
And  may be the following after the inner join sys.objects Obj on Obj.object_id=Indx.object_id line:
[code...

Hi, how many chars is the varchar column?
Possible extend it, and using a base 64 string (hex), and use convert from varbinary to varchar?

Thanks Ski, fix an update. Here is the correct links
https://docs.microsoft.com/sv-se/sql/ssms/visual-db-tools/visual-database-tools
https://www.mssqltips.com/sqlservertip/1816/getting-started-with-sql-server-database-diagrams/

may be the following can help
importing large SQL files

Sample for IP-4 numbers Using a CHECK constraint to validate IP addresses

Nice feature using dbo.sp_HelpText.

Note, that all CREATE is changed to ALTER!

1. Should we mark all procedures for recompilation, when upgrading to a new server version?

2. When the database is changed, like adding indexes or changing data in indexed columns, is...

The article Searching for Strings in SQL Server Databases" could also be interesting, see

Also take a look at this article Tally OH! An Improved SQL 8K “CSV Splitter” Function[/url]

Is it for documentation of known existing database?

You could use the builtin diagram function.

Option 1, using separate schema, dbo, product1, product2, product3, product4, seems a good choice. Move common things to the dbo schema.

Any migration to one database in future?

Lynn Pettis (10/21/2015)

---

Determine if ColumnA has duplicate values:

select

ColumnA,

count(*)

from

dbo.MyTable

group by

ColumnA

having

count(*) >...