"sp_who2" works for me...

Wonder whether someone could pass some SQL that will list everything that we get as output from sp_who2

Jeff M

What we need is to be able to do via T-SQL and also we need to get the def for all tables ( Not just picking one at a...

Reply to Post #1760966 from Lynn

The answer is "YES" ( I mean I am able to modify the code )

Why do I need the code ?

I have to copy tables...

Reply to Brandie

As a developer there is no need to know every nut and bolt of SQL sever.

With time we acquire more knowledge.

BTW- Thanks for your approach trying to teach...

I am pleased with what I picked from the INTERNET. Works well!

However if you do like to share your code ( or solution ) I will be more than...

Lynn: Let me make this simple.

I don't have a need to understand how SQL SERVER works. That is not a part of my job. Something like this, Microsoft should have...

Eirikur Eiriksson (2/12/2016)

---

Phil Parkin (2/12/2016)

---

Grumpy DBA (2/12/2016)

---

"Give a man a fish and he eats for a day. Teach a man how to fish and he eats for a lifetime."

I...

Wait, if you do not know how to do this, and you do not want to try to follow suggestions of others on how to do this, how can you...

Sean:

Here you go:

Whether it is accurate or not.. Your decision

http://sqlindia.com/generate-table-definitions-using-tsql-sql-server/

Lowell:

The one I picked ( I did a quick search ) uses the following objects.

You mentioned stuff from INFORMATION_SCHEMA is lacking some info.

Can you mention a few ?

INFORMATION_SCHEMA.TABLES

INFORMATION_SCHEMA.COLUMNS

INFORMATION_SCHEMA.COLUMNS

sys.identity_columns

sys.columns

information_schema.table_constraints

sys.indexes

Sean:

As promised I will share it later. Why ? I picked the sp from a website ( just a hour ago ). Before I share it, let me make sure...

Well then can you be kind enough to share that code with us please ?

If you are not willing that is fine. No hard feelings!

Have a great day!

BTW -...

I am not trying to be mean here....

But the real answer is...

"[There is no way to do that in one or several SQl statememts]"

However I found the perfect resource out...

Jeff M:

Please refer to Post #1760015.

I changed the code to include 2 extra rows in table @a that are not in table @b-2.

So you definitely have to use both tables....

RBAR:

"scanning the table twice" ???.

We have 2 different tables ?

Also it would be nice if you could throw the syntax ( I have not used the ROLLUP before )