sql - Getting list of tables, and fields in each, in a database - Stack ...
Jan 7, 2009 · I'm looking at creating a basic ORM (purely for fun), and was wondering, is there a way to return the list of tables in a database and also the fields for every table? Using this, I want to be able to loop through the result set (in C#) and then say for each table in the result set, do this (e.g. use reflection to make a class that will do or ...
database - How to randomly select rows in SQL? - Stack Overflow
Feb 24, 2009 · On SQL Server, you need to use the NEWID function, as illustrated by the following example: SELECT CONCAT(CONCAT(artist, ' - '), title) AS song FROM song ORDER BY NEWID() When running the aforementioned SQL query on SQL Server, we are going to get the following result set:
SQL Server search for a column by name - Stack Overflow
Sep 21, 2010 · 2) object name (including schema) 3) object type (table/view) 4) data type (nice format: varchar (6) or numeric (5,2), etc.) 5) null/not null. 6) information on identity, check constraint, and default info. try this: DECLARE @Search varchar(200) SET @Search='YourColumnName' --can be a partial or a complete name. SELECT.
sql - How to find a string inside a entire database? - Stack Overflow
Here is an easy and convenient cursor based solution. DECLARE @search_string VARCHAR(100), @table_name SYSNAME, @table_id INT, @column_name SYSNAME, @sql_string VARCHAR(2000) SET @search_string = 'StringtoSearch' DECLARE tables_cur CURSOR FOR SELECT name, object_id FROM sys.objects WHERE type = 'U' OPEN …
sql server - How do I get list of all tables in a database using TSQL ...
Oct 6, 2008 · 8. Any of the T-SQL code below will work in SQL Server 2019: -- here, you need to prefix the database name in INFORMATION_SCHEMA.TABLES. SELECT TABLE_NAME FROM [MSSQL-TEST].INFORMATION_SCHEMA.TABLES; -- The next 2 ways will require you to point. -- to the specific database you want to list the tables.
How do I shrink my SQL Server Database? - Stack Overflow
Jan 13, 2009 · Step 2: Run a database shrink, moving all the pages to the start of the files. Step 3: Truncate the transaction log again, as step 2 adds log entries. Step 4: Run a database shrink again. My stripped down code, which uses the SQL DMO library, is as follows: SQLDatabase.TransactionLog.Truncate();
database - how to get current datetime in SQL? - Stack Overflow
Aug 5, 2009 · For SQL Server use GetDate () or current_timestamp. You can format the result with the Convert (dataType,value,format). Tag your question with the correct Database Server. answered Aug 5, 2009 at 14:12.
A beginner's guide to SQL database design - Stack Overflow
29. Experience counts for a lot, but in terms of table design you can learn a lot from how ORMs like Hibernate and Grails operate to see why they do things. In addition: Keep different types of data separate - don't store addresses in your order table, link to an address in a separate addresses table, for example.
sql - How do I list all the columns in a table? - Stack Overflow
Oct 16, 2009 · Microsoft SQL Server Management Studio 2008 R2: In a query editor, if you highlight the text of table name (ex dbo.MyTable) and hit ALT + F1 , you'll get a list of column names, type, length, etc. ALT + F1 while you've highlighted dbo.MyTable is the equivalent of running EXEC sp_help 'dbo.MyTable' according to this site
sql - Find out current database name (MSSQL) - Stack Overflow
Sep 15, 2022 · With the MSSQL queries below, you can check the current database: SELECT DB_NAME() GO. master. In addition, if you don't specify a database on sqlcmd, "master" database is used by default. edited Feb 9, 2023 at 5:28. Henry Ecker ♦.