Microsoft SQL server database question

[Rabbo]

i am using this database for the first time for testing of data in tables.

Na doubt left lo unna multiple tables  ni , query window lo one time lo ela drag cheyochu ?

i have 300 table names list and i might have to do it in future , so manual ga select cheyadamu not an option 

[naas]

5 minutes ago, Rabbo said:

i am using this database for the first time for testing of data in tables.

Na doubt left lo unna multiple tables  ni , query window lo one time lo ela drag cheyochu ?

i have 300 table names list and i might have to do it in future , so manual ga select cheyadamu not an option 

Why do you need to drag? what you want to do?

Otherwise, use system tables to generate query similar to below.

SELECT 'SELECT ['+ name + '_RowCount] = COUNT(*) FROM [' + OBJECT_SCHEMA_NAME(object_id) + '].[' + name + ']'
FROM sys.tables 
ORDER BY name

 

 

[kranthi111983]

14 minutes ago, Rabbo said:

i am using this database for the first time for testing of data in tables.

Na doubt left lo unna multiple tables  ni , query window lo one time lo ela drag cheyochu ?

i have 300 table names list and i might have to do it in future , so manual ga select cheyadamu not an option 

intake emi cheyyali bhayya nuvvu? 300 tables ni drag cheyyadam deniki ? Management Studio lo  'New View' create cheste tables add chese option lo vastadhi

[Pori]

[Bangaruu]

6 minutes ago, Pori said:

pori 

[nrikittu]

LTT...